Date/time formula

[Robert]

Hello,

I am trying to add up a number of hours to a date, but I do not manage
to get a result.

Example:

Cell A1: 30/03/2005 22:00 (dd/mm/yyyy hh:mm)
Cell A2: 5 (hours)
Cell A3: A1+A2 (Result: 31/03/2005 03:00)

Can someone tell me which formula to use?

Thanx!

Rgds,
Robert

 

[OJ]

Hi,
In a3 put this..

=A1+(a2/24)

Hth,
OJ

 

[Dave Peterson]

This is at least the third time you've asked.

If you're looking for old posts:

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm