Adding time in Excel

  • Thread starter Thread starter Robert King
  • Start date Start date
R

Robert King

I am creating a self calculating timesheet that converts
Hours and minutes to hours and tenths of an hour and then
totals them. can this be done and if so could someone help
me or e-mail and example?

Thank You in Advance
 
Hi Robert!

You can convert the times individually to hours by simply multiplying
them by 24.

You can calculate the total in decimal hours for using:
=SUM(A1:D1)*24

You can total hours by normal sum but note that the answer should be
formatted [hh]:mm to prevent more than 24 rolling over a day.

Just remember that times are recorded 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.
 
Back
Top