View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
deusy
 
Posts: n/a
Default How do I write the formula to calculate someones time worked

I would like to use excel spreadsheet and calculate a simple payroll time
card. A person start time to work is 10:15 pm (cell A 1) and end time is
2am (cell B 1). What would be the formula for cell c1 to calculate the total
number of hours worked which would be 3 3/4 hours total worked. .