How can I do calculations in hours and minutes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to keep track of the hours I spend on a project. I have created
a worksheet where I can put in start and finish times using 24 hr clock
notation. When I try to add the time spent each day to give a weekly total I
get a time of day answer, eg if I have spent 25hr in total in a week the
result I get is 01:00:00. Does Excel not have a function to deal with
additions of hours, min, sec?
 
How is the cell you are using for the total formatted? Try using a custom
formatting of hh/dd/ss
 
On Mon, 8 Nov 2004 08:01:45 -0800, Ray Hughes, CAMSFC <Ray Hughes,
I am trying to keep track of the hours I spend on a project. I have created
a worksheet where I can put in start and finish times using 24 hr clock
notation. When I try to add the time spent each day to give a weekly total I
get a time of day answer, eg if I have spent 25hr in total in a week the
result I get is 01:00:00. Does Excel not have a function to deal with
additions of hours, min, sec?
Click to expand...

use custom format of [h]:mm:ss


--ron
 
Back
Top