View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Harker Norman Harker is offline
external usenet poster
 
Posts: 162
Default Calculate time worked

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

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Herb" wrote in message
...
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 AM
Please help