I am trying to add 2.44 hours in a different cell What do I do???
R roundabout Jul 21, 2006 #3 I always enter times in hh:mm:ss format. So 2.44 would be entered as 2:44:00 So the time now plus 2hrs 44 mins would be =NOW()+"02:44:00" And format your cell as time Hope this helps Lee
I always enter times in hh:mm:ss format. So 2.44 would be entered as 2:44:00 So the time now plus 2hrs 44 mins would be =NOW()+"02:44:00" And format your cell as time Hope this helps Lee
D Dave Peterson Jul 21, 2006 #4 Is this 2.44 hours or 2 hours 44 minutes? If it's 2.44 hours: =a1+(2.44/24) (format as time) if it's 2:44: =a1+time(2,44,0)
Is this 2.44 hours or 2 hours 44 minutes? If it's 2.44 hours: =a1+(2.44/24) (format as time) if it's 2:44: =a1+time(2,44,0)
