Overview Chat Bike Members News Women
Viewing 3 posts - 1 through 3 (of 3 total)
  • excel question, incorrect time formats
  • mrmo
    Free Member

    got some data, two times and i need the the difference, so far so easy. But the person who entered the times used a general format and not a time format.

    Is there away to get Excel to treat these numbers as times and not as decimals.

    Posted 14 years ago
    pennine
    Free Member

    Example:

    Type 10:00 in A1 and format to general

    In B1 enter =TIMEVALUE(A1) and format as TIME

    Posted 14 years ago
    djglover
    Free Member

    put them in notepad, find and replace . with :, put back in excel

    Posted 14 years ago
Viewing 3 posts - 1 through 3 (of 3 total)

The topic ‘excel question, incorrect time formats’ is closed to new replies.

Overview Chat Bike Members News Women