calculating hours into date format

[Guest]

hi

I would like a formula that will allow a user to input a figure (hours and
minutes) into a cell that will calculate the end date and time based on a
start date and time. For example,

Enter 30 hours, static start time is 01/01/04 00:00hrs, the formula would
then calculate that the end figure is 02/01/04 06:00hrs. Essentially it is
calculating the number of hours & mins added onto the start date with the end
result a date and time later than the hours & mins entered

Hope this makes sense!

 

[Frank Kabel]

Hi
in A1 put your date
in B1 enter your hours in the format hh:mm
C1:
=A1+B1
and format as date/time