Now () Formula

[Uli Hildebrand]

I am trying to add 2.44 hours in a different cell What do I do???

 

[Mallycat]

try adding this TIME(2,0.44*60,0

 

[roundabout]

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

 

[Dave Peterson]

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)