Display HOURS in one cell and MINUTES in another

[chris1965]

I am creating a overtime tracking sheet using military time format. Example: 1930 hrs. How can I have 19 display in cell C3 and 30 displayed in cell C4 without display a colon? Thank you.

[Pete_UK]

Try this:

C3: =HOUR(C2)
C4: =MINUTE(C2)

assuming C2 has your time.

Hope this helps.

Pete

[chris1965]

Thank you for your reply Pete. Unfortunately this didn't work. I have formatted C3 to "hh" and entered "C3: =C2" and it displays "19" as I want. The problem is with the Minutes. I formatted C4 to "mm" under custom setting and the entered "C4: =C2" and 01 is whats displayed.

[JasperD]

Remove your formatting and try Pete's solution again... it works fine

[Pete_UK]

Use my formulas, but format both cells as General or Number.

Hope this helps.

Pete

[chris1965]

I removed the formatting and Pete code works excellent. Thank you Pete and Jasper.