Solved Break time total formula

July 18, 2015 at 10:33:33
Specs: Windows 7
((D4-C4+(D4<C4))*24)>4 THAN V4=0.33
Note: 0.33 means 21 minutes break.
How can we write this formula in excel.

See More: Break time total formula

Report •


#1
July 18, 2015 at 11:05:48
✔ Best Answer
Put this in cell V4

=IF((D4-C4+(D4<C4))*24>4,0.33,"")

Also, you might want to take a look at this site,
it will help you immeasurably in working with Dates / Times:

http://www.cpearson.com/excel/datet...

I don't think your formula will do, what you want it to do.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
July 18, 2015 at 11:26:50
THAT'S WORK PERFACT, THANKS MAN. APPRICATE.

Report •

Related Solutions


Ask Question