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

Lawrence

 

excel

1 Reply

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

    Hi Lawrence_Lam_320​ 

    The problem is you have a single date in "16-01-2026 00:30". So calculating cumulated hours as you expect is - in principle not possible - not making an assumption like below:

    in B1 with you text value in A1:

    =VALUE( A1 ) - ( DATEVALUE( A1 ) -1 )

    and format B1 with Custom Number: [hh]:mm

Resources