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.

[TABLE="width: 111"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]17/09/2018 00:00[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 00:15[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 00:30[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 00:45[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 01:00[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 01:15[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 01:30[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 01:45[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 02:00[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 02:15[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 02:30[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 02:45[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 03:00[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 03:15[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 03:30[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2018 03:45[/TD]
[/TR]
</tbody>[/TABLE]

 

[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