Thread
:
Calculate time worked
View Single Post
#
2
Posted to microsoft.public.excel.programming
Norman Harker
external usenet poster
Posts: 162
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
Reply With Quote
Norman Harker
View Public Profile
Find all posts by Norman Harker