Excel 2007 : Converting a text date and time into a number

Hi Laura,

Is your time is also in Text format?
If not, you can simply format that as General and get to know the value. Alternatively, you can use Value function to get the respecitve number for that date:-

Please Login or Register  to view this content.

Where a1 contains the time.

Assuming you have the text date in cell c24, use following formula to convert it it number:-

Please Login or Register  to view this content.

Type following as well to support above formula:-
colJ colK
Jan 1
Feb 2
Mar 3
..
..
Dec 12


Regards,
DILIPandey

<click on below 'star' if this helps>