Forum Discussion

Lawrence_Lam_320's avatar
Lawrence_Lam_320
Copper Contributor
Jan 16, 2026

is it possible to capture HH:MM from the cell in text format DD-MM-YYYY HH:MM

Hi Expertise,  Need you help again. I need to capture the HH:MM from another cell DD-MM-YYYY HH:MM (text format) as below From 16-01-2026 00:30 (text format) To 24:30 (HH:MM format)   Regards L...
excel
Ka_ChunL's avatar
Ka_ChunL
Copper Contributor
Jan 17, 2026

Hi Lorenzo, 

Thanks for your great help. I tried to use your formula in B1 and format cell B1 as [hh]:mm but i cannot get the correct result like yours. Actually, I need to calculate OT hours using OT Start time and End time. I have a problem when OT start time and end time are not in same day. The example like this. Could you please give me some advise? Thanks

OT Start Time : 22:30

OT End Time : 02:30

OT Hours : 4.00

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jan 26, 2026

    Hi Ka_ChunL​ 

    (Apologies for the delay but this site/forum did not notify me)

    I have a problem when OT start time and end time are not in same day

    Understood but you posted Start Time and End Time with Time values only. Post you complete Date Time values instead - Please