Displaying A Duration in Time on a graph with general number formatted axis
Results 1 to 3 of 3

Thread: Displaying A Duration in Time on a graph with general number formatted axis
Thanks Thanks: 0 Likes Likes: 0

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

    Default Displaying A Duration in Time on a graph with general number formatted axis

    Hi,

    I'm looking for some help please.

    I need to find a way of including a value that is being displayed as a duration (e.g. 12:32 as mm:ss) but is inserted into excel using the decimal number system (as it allows me to add different times together).

    Generally these values that I am working with all lie between 3mins and 35mins (03:00 and 35:00).

    I already have a graph where one axis uses this scale, so it would be a huge help if I could use this graph to also display my duration information.

    Is there any way to do this? Currently the data is on the graph but is down the bottom as the actual decimal value that excel reads is something like 0.001232.



    Thank you for your help.

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,745
    Post Thanks / Like
    Mentioned
    66 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Displaying A Duration in Time on a graph with general number formatted axis

    For info you can input times in as normal times (in example below 4:6:7 and 0:25) and add them together with custom format as illustrated below

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    E
    F
    86
    FORMAT Duration1 Duration2 SUM FORMULA
    87
    [h]:mm:ss
    4:06:07
    0:25:00
    4:31:07
    =SUM(B87:C87) hours minutes and seconds
    88
    89
    [m]:ss
    246:07
    25:00
    271:07
    =SUM(B89:C89) minutes and seconds
    Sheet: Sheet 5

    For graphing
    - convert the values (in another range) and graph those values

    To convert durations into hours
    - multiply by 24
    - format the cell as a number

    To convert durations into minutes
    - multiply by 24 X 60
    - format the cell as a number

    To convert durations into seconds
    - multiply by 24 X 60 X 60
    - format the cell as a number
    Last edited by Yongle; Apr 3rd, 2019 at 04:29 AM.

  3. #3
    New Member
    Join Date
    Oct 2018
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Displaying A Duration in Time on a graph with general number formatted axis

    Brilliant, that has worked! Thank you!!

Some videos you may like

User Tag List

Tags for this Thread

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
  •