=((B1-A1)+(D1-C1))*24 (formatted as general or number, not as time) gives
5.65 hours
(assuming that your 4 times are in A1 to D1 respectively).
--
David Biddulph

"smartgal" wrote in message
...
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!