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

1. ## 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.

2. ## 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

3. ## Re: Displaying A Duration in Time on a graph with general number formatted axis

Brilliant, that has worked! Thank you!!