Quote:
Originally Posted by lsainsbury
Total hours overtime....
1 = correct!
Right.....so what would the formula be ?
|
How about this:
=IF((TIMEVALUE("7:30 AM")-A2)<0,0,TIMEVALUE("7:30 AM")-A2)+IF((B2-TIMEVALUE("18:30"))<0,0,B2-TIMEVALUE("18:30"))
She ain't pretty, but...
Start Stop Overtime
08:00 16:00 00:00
07:00 16:00 00:30
08:00 19:00 00:30
07:00 19:00 01:00