formula help, please?

[kins]

I need to a formula which takes the 00:30 number from the 00:00, the 00:00 from the 00:30 on the next day and so on. Basically I don't want to include the 00:15 or 00:45 in my formula when I take one number from the other. I sure there is an easy way.

17/09/2018 00:00

17/09/2018 00:15

17/09/2018 00:30

17/09/2018 00:45

17/09/2018 01:00

17/09/2018 01:15

17/09/2018 01:30

17/09/2018 01:45

17/09/2018 02:00

17/09/2018 02:15

17/09/2018 02:30

17/09/2018 02:45

17/09/2018 03:00

17/09/2018 03:15

17/09/2018 03:30

17/09/2018 03:45

<colgroup><col></colgroup><tbody>
</tbody>

 

[AlanY]

excel stores the date/time in numerals, e.g. 17/09/2018 00:15 is 43360.0104.

to get rid of the decimals (i.e. the time) you can use the INT() function, then format the cells as date.

 

[kins]

cheers Alan, I'll give it whirl