formula - time

  • Thread starter Thread starter claude
  • Start date Start date
C

claude

i have several cells in 1 row which are formatted as a
time (eg. 8:00) which denotes the hours worked in a day.
(the spreadsheet is a roster).

i want to put in a formula which will add the total hours
worked for the week. but the spreadsheet seems to have a
problem with adding times.

any suggestions?
 
Hi Claude!

Example:

=SUM(A1:G1)
Custom Format [hh]:mm

This prevents >=24:00 from rolling over to a day.

If you want the answer in decimal form based on hours worked use:

=SUM(A1:G1)*24
Format General

Times are stored as a decimal part of a day.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
claude said:
i want to put in a formula which will add the total hours
worked for the week. but the spreadsheet seems to have a
problem with adding times.
Click to expand...

It has no problem handling times, it just formats them using a 24 hour roll
back to 00:00. Try giving the sum of time cell the format [hh]:mm:ss.
 
With all of your times enter in column A
you can use

=SUM(A:A)/"1:0:0"

Format this cell as a number and you will get a total for all hours in
column A

Randall
 
Back
Top