Home

Charting activity time duration in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-285283%22%20slang%3D%22en-US%22%3ECharting%20activity%20time%20duration%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285283%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I'm%20trying%20to%20chart%20activity%20duration%20in%20excel%20that's%20been%20calculated%20from%20start%20and%20end%20times%20on%20a%20given%20day.%3C%2FP%3E%3CP%3EThe%20duration%20column%20is%20formatted%20as%20hh%3Amm%20from%20the%20custom%20field%20format.%20However%2C%20when%20I%20turn%20it%20into%20an%20area%20chart%2C%20the%20y%20axis%20which%20is%20the%20duration%20(x%20axis%20is%20activity)%20is%20shown%20as%20the%20actual%20time%20and%20not%20the%20duration%2C%20despite%20being%20formatted%20as%20hh%3Amm.%20I've%20even%20tried%26nbsp%3B%20formatting%20the%20y%20axis%20as%20both%20time%20and%20custom%20and%20it%20still%20shows%20the%20time%20of%20day%20rather%20than%20duration.%20Any%20help%20much%20appreciated!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-285283%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285893%22%20slang%3D%22en-US%22%3ERe%3A%20Charting%20activity%20time%20duration%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285893%22%20slang%3D%22en-US%22%3E%3CP%3EThat's%20great%20Sergei%20-%20thank%20you%20very%20much!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERichard%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285823%22%20slang%3D%22en-US%22%3ERe%3A%20Charting%20activity%20time%20duration%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285823%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Richard%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20y-axis%20units%20you%20may%20define%20major%20one%20manually%2C%20let%20say%20as%200.0833333%20which%20is%20equal%20to%202%20hours%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20615px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F59620i0D35990E8464C14C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285806%22%20slang%3D%22en-US%22%3ERe%3A%20Charting%20activity%20time%20duration%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285806%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%20-%20thanks%20for%20your%20idea.%20Sample%20data%20attached%20and%20see%20the%20random%20y%20axis%20values%3F%3C%2FP%3E%3CP%3EAny%20other%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERichard%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285464%22%20slang%3D%22en-US%22%3ERe%3A%20Charting%20activity%20time%20duration%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285464%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Richard%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBetter%20if%20you%20attach%20some%20sample%20file.%20However%2C%20did%20you%20try%20format%20duration%20as%20elapsed%20time%20%5Bhh%5D%3Amm%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-655848%22%20slang%3D%22en-US%22%3ERe%3A%20Charting%20activity%20time%20duration%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-655848%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Sergei%2C%20I've%20been%20struggling%20with%20this%20one%2C%20and%20your%20answer%20really%20helped!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EKen%3C%2FP%3E%3C%2FLINGO-BODY%3E
Richard Kimber
New Contributor

Hi - I'm trying to chart activity duration in excel that's been calculated from start and end times on a given day.

The duration column is formatted as hh:mm from the custom field format. However, when I turn it into an area chart, the y axis which is the duration (x axis is activity) is shown as the actual time and not the duration, despite being formatted as hh:mm. I've even tried  formatting the y axis as both time and custom and it still shows the time of day rather than duration. Any help much appreciated!!

5 Replies

Hi Richard,

 

Better if you attach some sample file. However, did you try format duration as elapsed time [hh]:mm ?

Hi Sergei - thanks for your idea. Sample data attached and see the random y axis values?

Any other ideas?

 

Thanks,

 

Richard

Hi Richard,

 

If you mean y-axis units you may define major one manually, let say as 0.0833333 which is equal to 2 hours

image.png

 

That's great Sergei - thank you very much!

 

Richard

Thanks Sergei, I've been struggling with this one, and your answer really helped!

 

Regards

Ken