Time formula help

[montefisto]

I am trying to produce a formula for calculating the scheduled time of a task in a project, based on the time the project starts (zero time) and the hour point the task should be performed at.

I am hoping that someone can help me as I am becoming a tad frustrated with such a simple task.

I am having problems in particular with the negative hour ponts (-24Hr, -48Hr etc), where the calculation involves counting back into a new day.

I have attached a spread sheet to better illustrate the problem. Column A shows the number of hours (decimal time point i.e. 1.5 equals 1hr 30min) in reference to the zero time at which the task should be performed. In column B i would like to calculate the time of the task based on the hourpoint in column A and the zero time (shown in cell E1). I have manually typed the figures in red in column C as a reference to show the correct answer to the calculation I wish to perform.

The attached sheet has a simple version of the spread sheet i use for this function. I can add further column if necessary. The hour-points I wish to use will not always be regular and they will not always be integers, so they cannot be calculated from the previous scheduled time.

Please, please, please, help!!

[daddylonglegs]

Try this formula in C2

=MOD(E$1+A2/24,1)

format as time (if necessary) and copy down

[montefisto]

Thankyou very much!!!!