time calculation

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

I wish to have a time sheet that I can enter the
employee's hours and the spreadsheet will calculate the
hours work eg.

start 6:30am finish 4:30pm = 10HOURS

what formula would I use to calculate the 10 hours. I am
aware that the 10 hour includes a lunch hour.

Any help would be greatly appreciated.

Regards

Phil
 
Sorry Phil

Two things.

First enter times after 12:00 noon as PM. ex 4:30 PM or enter them based on
24 hour clock ex 16:30 for 4:30 PM

And also modify the formula to

B1-A1+(A1>B1)

when the starting time is greater than the ending time the last term = 1 and
corrects the error you would encounter if start time = 10 PM and end time =
1:AM next day.

PC
 
Back
Top