Now () Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Uli Hildebrand - 21 Jul 2006 04:19 GMT

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

Reply to this Message

Mallycat - 21 Jul 2006 07:43 GMT

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

Reply to this Message

roundabout - 21 Jul 2006 11:02 GMT

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 am trying to add 2.44 hours in a different cell What do I do????
>
[quoted text clipped - 4 lines]
> http://www.mcse.ms/member.php?action=getinfo&userid=36614
> View this thread: http://www.mcse.ms/showthread.php?threadid=563556 *

--
roundabout

Reply to this Message

Dave Peterson - 21 Jul 2006 13:53 GMT

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)

> I am trying to add 2.44 hours in a different cell What do I do????
>
[quoted text clipped - 3 lines]
> Uli Hildebrand's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36614
> View this thread: http://www.excelforum.com/showthread.php?threadid=563556

Signature

Dave Peterson

Reply to this Message

Rate this thread: