Totaling Formulas

  • Thread starter Thread starter Eleanor
  • Start date Start date
E

Eleanor

I am working on a time sheet and I used the formula =MOD
(B1-A1,1) and now I need to add those cells together and
it is not giving the correct answer. For instance I know
I worked 31 hours but it is giving the total of 16.

Can someone help?

Thank You
Eleanor
 
First, the =MOD(B1-A1,1) formula will only work if the elapsed time
between A1 and B1 is <24 hours. If it will be more than 24 hours you
need to include dates, either as separate cells or, better, using
date/times in each cell:

A1: 1/22/2004 05:00
B1: 1/23/2004 17:00

C1: =B1-A1 ===> 36:00

when C1 is formatted with Format/Cells/Number/Custom [hh]:mm

If instead you're totalling times that are less than 24 hours and coming
up with a bad value, make sure your total cell is formatted as above to
keep XL from "rolling over" the time after 24 hours.
 
Back
Top