Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time subtraction | Excel Worksheet Functions | |||
subtraction off time after midnight | Excel Worksheet Functions | |||
time subtraction problem | Excel Worksheet Functions | |||
subtraction with time format cells | Excel Worksheet Functions | |||
decimal time subtraction please. | Excel Worksheet Functions |