Add 2.433 hour increments to a starting number of hours every 24 hours

[Juleskor]

Hi guys,
Is it possible to add 2.433 hour increments to a starting figure (in hours) every 24 hours?
Basically, I have a starting date of 26/04/2013 and the hours of 49:44:00. What I would like to do is if I open up the spreadsheet some time in the future that it will calculate and add 2.433 hours to 49:44:00 for every 24 hours after 26/04/2013.
Hope this makes sense and hope someone out there is able to help?
Thanks in advance
Regards

[:) Sixthsense :)]

In which cells(s) the Date 26/04/2013 and Time 49:44:00 is present in your worksheet?

[Juleskor]

Hi Sixthsense,

The start date of 26/04/2013 is in cell B1 and the 49:44:00 is in cell B2.

I have attached the document if that helps.

Regards

[:) Sixthsense :)]

May be this..

In D2 cell

Please Login or Register  to view this content.

Format the D2 cell as

Please Login or Register  to view this content.

[Juleskor]

Hi Sixthsense,

The value I got is 2.072222222. Is this correct?

Regards

[:) Sixthsense :)]

Please refer the attached file for details

[Juleskor]

Ah, it works if I make the cell format as [hh]:mm:ss as opposed to your previous post which had [h]:mm:ss.

Thanks very much for this, that's fantastic

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback

PS: Yes, little bit confused