Duration Error on Burn Chart

10 views
Skip to first unread message

Sally Neal

unread,
Mar 29, 2018, 6:42:01 AM3/29/18
to Google Visualization API
I am trying produce a burn chart in google sheets to record time remaining on a project, which has to be formatted as 'duration' but any data over 24 hours plots incorrectly. It seems to be wrapping values over 24 hours back on themselves, so for example 30:00:00 plots at 06:00:00 (which is 30-24). So it seems to be treating the 'duration' as if they're numbers on a clock when I need them to work as normal numbers - i.e. go over 24 hours. 

Here's the Sheet...


and a screenshot is attached

Can anyone help?

Thanks
Screen Shot 2018-03-29 at 11.40.40.png
Reply all
Reply to author
Forward
0 new messages