Results 1 to 4 of 4

How do i turn a column of these (62000) into this (06:20:00)

Threaded View

  1. #1
    Registered User
    Join Date
    09-06-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    5

    How do i turn a column of these (62000) into this (06:20:00)

    Hi Guys

    I have a problem. I've been trying to make an add-in that compares two columns and highlights any times that are more than 15 minutes apart.

    The only problem, is that one of the columns is in hh:mm:ss format and the other is just numerical.

    I've attached the file if anyone wants a closer look.

    I'm eally stuck and would appreciate any help

    Thanks

    Colin
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1