Forum Discussion
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...
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
Thanks Sergei, I've been struggling with this one, and your answer really helped!
Regards
Ken
That's great Sergei - thank you very much!
Richard
