Okay, let me just say what I'm trying to get to:

start time: 8:58 am
out for lunch: 12:02 pm
back from lunch: 1:27 pm
end time: 4:02 pm

Our time clock calculates the day's total as 5.6 hours. I need to be able
to do the same.

"Sheeloo" wrote:

If your time is in A1 use this in A2 to get what you want
=A1*24

"smartgal" wrote:

I am trying to create a spreadsheet in which I can enter an actual time (1:13
pm) and have it convert it to a decimal. Tried excel help, to no avail.
Output of this is I want an employee to enter their start and end times each
day and have the sheet calculate the time spent at work. Thanks!