Dom
Member
Registered: 13th Sep 03
User status: Offline
|
Currently have an Excel Timesheet (Date, Time in, Time Out, Overtime worked) but the code i have to work out the overtime is a little basic and causes errors if i worked under my 8 hr day.
code:
Current formula -
=IF((OR(C6="",D6="")),TIME(0,0,0),((D6-C6)-TIME(8,0,0)))
Does anyone know a formula that would calculate overtime as well as 'undertime'? ie: if i work 20 minutes over it would display 00:20, if i worked 20 minutes under it would display -00:20?
Also, is there a formula that could sum up the overtime column (whether it's overtime or 'undertime') that would display the current amount of overtime i have? (again could display 00:00 or -00:00)
cheers all 
[Edited on 04-03-2008 by Dom]
|
| Aug '08' Total Vauxhall Feature Car 
