» Adding Time Values
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
When using a standard SUM formula to add the time values in column B (=SUM(B2:B5)), a false result of 4:23 is returned, rather than the actual sum of 28:23.
Solution:
Excel's default time format does not allow a time value to exceed 24 hours. This is the cause of the above error.
To properly display a sum exceeding 24 hours, change the format of the cell from "h:mm" to "[hh]:mm".
Book Store:
Recommended Books:
- Advanced modelling in finance using Excel and VBA
- Harry Potter and the Order of the Phoenix (Book 5)
- Keys to Reading an Annual Report (Barron's Business Keys)
- Financial Reporting and Analysis (2nd Edition)
- Writing Excel Macros with VBA, 2nd Edition
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
Adding time values
Caspar
I want to add e.g. ten minutes to a list of time values - how do I do this??
Adding time values
Ian
I changed the value from (h):mm to (hh):mm but the sum still will not go past 24hrs it reverts back to 0?:?? after passing a 24hrs period, I am trying to count the number of hours worked in a week period in hr:min value.
Any ideas??
Adding Time Values
Yvonne Wright
I wanted to be able to add working hours, but found that it would not calculate over 24hrs correctly. Once I opened this page the answer was there straight away no faffing around excellent I am well chuffed
Adding Time Values
Yvonne Wright
I wanted to be able to add working hours, but found that it would not calculate over 24hrs correctly. Once I opened this page the answer was there straight away no faffing around excellent I am well chuffed
Re: Adding Time Values
mreinders
Looking for a formula to compare two times as follows -
If a person's start time is 7:00 AM (Column A) and their actual login time is in Column B, Column C would show the following
if prior to 7:01 return 0,
if greater than 7:01 return 1,
if greater than 7:59 return 0,
if between 7:01 and 7:59 return actual minutes in Column D
Any suggestions would be greatly appreciated!
marty
Re: Adding Time Values
shg
Welcome to the forum, mreinders.Please take a few minutes to read the forum rules (link in the menu bar), and then start your own thread.

