[Solved] VBA: Convert decimal into time

  • I have a field where it has a decimal number representing time eg. 0.5 same as 50 minutes. Does anyone know how I can convert this decimal into a time format eg 0:50?

    Thanks in advance

  • Excel tracks time as a fraction of a day. So if 0.5 represents 50 minutes it is 50/60 (or 0.5/0.6) of an hour and (0.5/0.6)/24 of a day. Make this calulation and you should then be able to format the result (e.g., hh:mm:ss or whatever works best for you) as time.

    Working with time formats can be tricky. Dave has some great help/hints posted on this website ... I think they are found via the Excel Dates adn Times link at.


  • "Working with dates is a real hassle..."

    Shouldn't be, as long as you keep one thing in mind:

    If you don't enter a genuine date value to represent a date, your life will become hell later.

    For example, if 09/06/2003 is a Monday & you want to display the date as Monday, just enter the full date & apply the appropriate format (ddd in this case). having entered a date value, you can still do all the standard calculations - enter Mon as text & about all you can know is that it's a text string of lenght 3.

    Always enter a full date value


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!