View Single Post
  #1   Report Post  
Ronnie
 
Posts: n/a
Default how can I add cells in hours and minutes, eg 1.15 +1.45 to equal .

I am currently using Excel on a spread sheet to calculate hours and minutes.
I need to know how to convert the time entered so that it will calculate as
time and not normal figures. EG if I enter 1.15 and 1.45 I need it to total
as 3 hours and not 2.60.

Can you help.