Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Time format/duration help!!

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm driving myself crazy trying to figure this out. I have two sets of data that are pulled from databases, both representing the amount of time someone worked. One shows the time as a decimal in minues, for example 91.23 (91 minutes), and the other is shown in time format, example 1:31. My boss wants a total time worked but in order to add the data I need to have it in the same format. Just changing the cell format doesn't work. Also changing the format in the databases is out of the question. Does anyone know of a way to do this. I'm at a loss and ready to start pulling my hair out. Thanks!
    ~julee~

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try multiplying your time by 1440. Take the column that has 1:31; multiply it by 1440; and format the column to display a number to give 91 minutes.

    I hope this helps.
    Kind regards, Al.

    [ This Message was edited by: Al Chara on 2002-03-14 11:13 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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