Calculate time worked
 

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

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

Calculate time worked
 

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


--
Regards
Frank Kabel
Frankfurt, Germany


Herb wrote:
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