Adding time from calculated cells

Hi guys,

My turn.

I have a problem that I'm struggling with.

http://www.excelforum.com/excel-gene...00#post2782800

User inputs start and finish time in 24 hour clock style e.g. 15:00 etc

If finish time is next day (i.e works overnight) and start day is Fri/Sat or Sun then normal time is up to midnight and time and a half is from midnight to finish - otherwise normal time. Those formulae work fine.

I'm having problems having the totals in cols G & H to show actual hours for back office stats presumably. (111 and 25 hours)

I've tried all the usual sources and all manner of different formats but can't get it right. I've even tried setting "precision as displayed" but no.

The file is attached and I'd be grateful for assistance please.

Regards

Russell

Try

=IF(WEEKDAY(B5,2)>=5,IF(E5<D5,MOD(1-D5,1),E5-D5),MOD(E5-D5,1))

and

=IF(MOD(E5-D5,1)=G5,"",MOD(E5-D5,1)-G5)

needs more evaluation....

Employee timesheetevaluatefurthure.xlsx

Bob

That's great - works a treat. Vlady got us half way there with the totals by getting the time and a half tots correct and I was trying to prove the other one which should have been correct in theory.

Vlady

Thanks for your help.

Regards

Russell

Nice work guys. Many thanks.

http://www.excelforum.com/excel-gene...45#post2784145