Calculate time worked

[Guest]

Using Excel 2000:How do I calculate time worked by inputting start time, end time and get answer in format hours.decimal hours. I input time using TIME(Hours, Minutes, seconds). The result of subtraction is of format 1:45 A
Please help

 

[Norman Harker]

Hi Herb!

Since time is recorded as a decimal part of a day use:

=A1*24
Format General

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi
if A1 is your starting time and B1 your end time use
=(B1-A1)*24

if your working time can span midnight use
=(B1-A1+(B1<A1))*24