Forum Discussion

Copper Contributor

Nov 12, 2018

Charting activity time duration in excel

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, w...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Nov 12, 2018

Hi Richard,

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

Richard Kimber
Copper Contributor
Nov 13, 2018
Hi Sergei - thanks for your idea. Sample data attached and see the random y axis values?
Any other ideas?

Thanks,

Richard
Charting time duration for activity.xlsx16 KB
- SergeiBaklan
  Diamond Contributor
  Nov 13, 2018
  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
  
  Charting time duration for activity.xlsx19 KB
  - KenCollins
    Copper Contributor
    May 29, 2019
    Thanks Sergei, I've been struggling with this one, and your answer really helped!
    
    Regards
    Ken