Discussion Locked

Convert a timevalue to number in Excel

0 helpful

4 replies

by lathe May 14, 2003 last reply May 18, 2003 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How can I convert a time value to numberic value in Excel
eg:
11:50:45 AM
I like to cut this time to 3 parts as numeric value 11, 50 and 45.
Thanks

4 replies

Hour(x)
Minute(x)
Second(x)

where "x" = the timevalue or cell reference to the timevalue.

I probably should have noted that those formulae (Hour, Minute, Second) should have an "=" in front of them when used in a cell.

Poster rated this answer

This question was closed by the author

This discussion is closed to new replies.