Time divisions

[Khaldon]

I need help please with three formulas in Cell A1, A2 and A3 as follows:
Entered time value in cell A5 will be divided by the three cells above so cell A3 will result in a time value one hour more than cell A2, and A2 cell value will result in one hour more than A1 cell.

Example: if the entered time value in cell A5 is 8:00,
Cell A3 should reflect 3:40
Cell A2 should reflect 2:40
Cell A1 should reflect 1:40

[Roel Jongman]

try For all 3 cells:

=($A$5/3)-(ROW()-2)/24

oops.. small mistake use plus sign instead

=($A$5/3)+(ROW()-2)/24

[Khaldon]

Inserting the given formula as it is in all three cells and time value of 8:00 in cell A5 resulted in the following;

A1 4:40
A2 5:40
A3 6:40
For a to total of 17:00 instead of a desired 8:00 total time value!

[Pete_UK]

Put this in A1:

=(A$5-3/24)/3 +(ROWS($1:1)-1)/24

then copy into A2:A3.

Hope this helps.

Pete

[Pete_UK]

Thanks for the rep, Khaldon - glad it worked for you.

Pete