- Joined
- Oct 2, 2006
- Messages
- 1
- Reaction score
- 0
Hi
I am trying to create a chart to show a machines usage in time format against a maximum possible usage.
The figures i have are in the follwing format
example: 10:26:34 to represent 10 hours 26 minutes and 34 seconds.
I would like to display this figure on bar chart against a maximum usage figure of 40:00:00 (40 hours) and agianst a weekly date figure.
When i try to create a chart in the usualy way excel does not seem to recognise the time format and creates a chart that does not make much sense.
Any thoughts on how to do this?
These are the figures i'm working with.
Date
31/07/2006 07/08/2006 14/08/2006 21/08/2006 28/08/2006 04/09/2006 11/09/2006 18/09/2006 25/09/2006 02/10/2006
Duration
11:59:49 16:20:37 08:50:15 09:51:44 14:58:20 16:18:52 12:31:57 09:03:11 23:04:42 09:21:31
Max duration 40:00:00
Any help appreciated.
Thanks
I am trying to create a chart to show a machines usage in time format against a maximum possible usage.
The figures i have are in the follwing format
example: 10:26:34 to represent 10 hours 26 minutes and 34 seconds.
I would like to display this figure on bar chart against a maximum usage figure of 40:00:00 (40 hours) and agianst a weekly date figure.
When i try to create a chart in the usualy way excel does not seem to recognise the time format and creates a chart that does not make much sense.
Any thoughts on how to do this?
These are the figures i'm working with.
Date
31/07/2006 07/08/2006 14/08/2006 21/08/2006 28/08/2006 04/09/2006 11/09/2006 18/09/2006 25/09/2006 02/10/2006
Duration
11:59:49 16:20:37 08:50:15 09:51:44 14:58:20 16:18:52 12:31:57 09:03:11 23:04:42 09:21:31
Max duration 40:00:00
Any help appreciated.
Thanks