Just add them, for instance if you put 04/25/05 15:00 in A1 and 36:00 in B1,
then just add =A1+B1 and it will return 05/27/05 03:00
If you have a date with time and you use an integer for the hours you want
to add
36 then you need
=A1+(B1/24)
you probably need to reformat result
--
Regards,
Peo Sjoblom
"Martin B" wrote in message
...
Being a simple man i need a simple spreadsheet to add hours to predict a
finish time and date. I want to be able to add 36 hours to 15:00 Monday and
the spreadsheet tell me the finish is 03:00 Wednesday. I am not bothered
about the date so don't want the hassle of having to type them in everytime.
Seems simple but I can find anything suitable, any one got any suggestions?
Thanks in anticipation
Martin
|