LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Junior Member
 
Posts: 3
Default

Put the if statement on column D instead of column E because that is what is really changing, right? Also, time is always a little funky in excel if you don't use it right. So put the following in each column

A:
=time(hour,minute,second) for your example this would would =time(8,0,0)

Then in B do the same thing:
=time(18,0,0)

Column C will be the same =B-C

Column D has your if statement that will look like this:
=IF(C1=TIME(12,0,0),TIME(1,0,0),TIME(0,30,0))

That is saying that if the shift is 12 hours or longer report back a break of 1 hour otherwise report back a 30 min break. Last is your total billable hours in column E:

=C-D

Does that anwer your question?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time subtraction Dgwood90 Excel Worksheet Functions 3 December 20th 08 05:21 PM
subtraction off time after midnight Steved Excel Worksheet Functions 2 May 24th 06 01:46 AM
time subtraction problem Excel Worksheet Functions 6 July 15th 05 06:57 PM
subtraction with time format cells Stefano Excel Worksheet Functions 2 March 17th 05 03:06 PM
decimal time subtraction please. Steved Excel Worksheet Functions 6 November 25th 04 01:07 AM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"