Dates to change with times

[JakeMann]

Hi All,

On the attached sheet I have a date and time column.

The start date and time is in K3 and L3.

How can I automate the date so that the first instance of it going past midnight it changes to the following day?

Thanks
Jake

[Pete_UK]

Change the formula in L4 to this:

=MOD(L3+1/48,1)

and copy this down. Then you can have this formula in K4:

=K3+(L4<L3)

and copy that down.

Hope this helps.

Pete

[JakeMann]

Thank you Pete, as helpful as ever!

[Pete_UK]

Not worth a click on the "star", then?

Pete

[JakeMann]

I did... I'll do you another one!