Just subtract the start time from the end time.

A1 = start time = 1:13 PM
B1 = end time = 9:27 PM

=B1-A1

Format as [h]:mm

Result = 8:14

If the times might span past midnight then use this version:

A1 = start time = 11:13 PM
B1 = 7:27 AM

=MOD(B1-A1,1)

Format as [h]:mm

Result = 8:14


--
Biff
Microsoft Excel MVP


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