Thread: How do I write the formula to calculate someones time worked
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mbarron
 
Posts: n/a
Default How do I write the formula to calculate someones time worked
In order to calculate the time correctly, the cells must be a date-time
field, (especially if you are calculating times on two different days.

The formula would be (assuming start date-time is in A1 and end
date-time is in B1) :
=(B1-A1)*24

Reply With QuoteReply With Quote