View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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