Thread: Calculate time worked
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default 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
Reply With QuoteReply With Quote