Need a formula to divide the minutes of time into intervals

[benji1973]

Is there a formula I can use to divide the minutes of a time into 2 intervals with the result being one of these two (first half or last half)?

example I have time 9:48:34, I need the result from the formula to read "last half" because the minutes are between :30 & :59.

But if I have time 9:12:46 then I need the result to read "first half" because the minutes are between :00 & :29.

[MrShorty]

The MINUTE() function will return the minute part of a date/time value -- assuming these times are stored as actual numbers and not text: https://support.microsoft.com/en-us/...d-a84801a60589 Then you can use an IF() function to perform the decision logic. Something like =IF(MINUTE(time)<30,"first half","last falf")

[MarvinP]

Hi benji,

I think you want the Minute() function and then followed by an If(). See the attached where column A is random times and B is the Minute extractor and the C is the If statement.
Minute Splitter.xlsx

Looks like MrShorty and I agree on your answer....

[benji1973]

This formula worked perfectly! Thank you so much