How To Convert A Date/Time Serial Number

[Wolfgang]

Hi All,

how can I convert a Date/Time Serial number into Hours - Minutes and Seconds, please?!

My number is: 21967.3029253472

Thank you...

Best,
Wolfgang

[RichardSchollar]

Hi All,

how can I convert a Date/Time Serial number into Hours - Minutes and Seconds, please?!

My number is: 21967.3029253472

Thank you...

Best,
Wolfgang Hi Wolfgang Assuming that is an Excel date/time, then you can simply custom number format the cell as: [h]:mm:ss which will give you the split between total hours/minutes/seconds. If that isn't an Excel date/time, can you explain what you expect the answer to be? Richard

[Wolfgang]

Hi Richard,

Thank you very much for your fast answer...

In fact that's exactly what I did but then I chose the wrong format.

Best,
Wolfgang