I enjoy tried excel and enter the formulas ie =SUM (B2-B3)*24 etc.. but nought is working so I'm doing something wrong! I hold to enter stop, start for morning, afternoon and hours of darkness so it's not a simple 8-5 timesheet. Does anyone know how I can do this on excel, the tutorial contained by excel I copied and it's stopped, please comfort!
Answers: Go here
http://office.microsoft.com/en-us/templa...
You'll find greatly of time sheets template pick the one that will work the best for you.
Post and expurgate if you are still have trouble.
EDIT
If you want to do time here you go
If nobody EVER go chronological midnight then
In cell a1 7:30 PM -this is time in
In cell b1 8:45 PM -this is time out
In cell c1 =TEXT(b1-a1,”h.mm”) -this will convert time into a decimal number
In cell d1 =TEXT(B1-A1,"h") -this will make a contribution you the hours by themselves
In cell e1 =(c1-d1)/60*100 -this will grant you minuets converted into the percent of an hour
In cell f1 =e1+d1 -this will dispense you total time work beside minuets as a percent of an hour so you can multiply by wage
If you involve to be in motion historic midnight
In c1 =IF(B1-A1<0, TEXT(A1-B1,"h.mm"),
TEXT(B1-A1,"h.mm"))
In d1 =IF(B1-A1< 0, TEXT(A1-B1,"h"),
TEXT(B1-A1,"h"))
In e1 =(C1-D1)/60*100
In f1 =IF(B1-A1<0,24-D1-E1,D1+E1)
Look here.