PDA

View Full Version : [SOLVED] How To Convert A Date/Time Serial Number



Wolfgang
10-30-2007, 11:27 AM
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
10-30-2007, 11:47 AM
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
10-30-2007, 11:51 AM
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