Convert General Number To Hours?

I have been trying to come up with a resolution for this all day. I have the number 30.00 in let's say A2 that represents number of hours. I want it to be formatted in a way that shows 30:00:00(30 hours) so that I can add it to the current date and time. Is this possible?

You could do

=NOW()+TIME(A2,0,0)

Excel treats dates as numbers, so you dont have to format your hours input differently. If in A2 you have hours (in your example, 30 hours), then if you had current date and time in B2, using the formula

Please Login or Register  to view this content.

formula, then in column C2 you could use this formula

Please Login or Register  to view this content.

to get the date and time when the hours in A2 are added to B2 (current date and time).

That's wrong....ignore that

Try
=NOW()+A2/24

I apologize in advance for not attaching an excel sheet but this is what I am looking for. My current settings are general except the date and time at the top (05/06/2015 17:00) I want to add 30 hours to this time but I cant seem to get it to work correctly.
234.PNG

I figured it out . Lets say my current date and time was in cell B1 and the total hours in cell A2(General number format). You would then need to take B1+A2/24, change your format settings in the custom options to under time( [hh]:mm) and you're done. Thank you!

PS: I was off by an hour in my example

I believe in your example the input would be 31 hours, not 30, but, the formula in the yellow box would be

Please Login or Register  to view this content.

assuming that a2 is where the hours are being input. Also, make sure that you format the cell highlighted in yellow the same format as your current time cell.