| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with hours and minutes. Help please!
I want to draw a graph on something that happened over 24 hours
e.g. 0700 2 (i.e. 7am, value - 2) 0713 3 0905 12 1307 2 1906 6 2305 9 (i.e. 11.05pm, value 9) Can I get Excel to put time on the X axis? Can I get Exel to calculate time difference from 7.13am to 9.05am - i.e. it's not 0905 - 0713 = 0202; it should be 1hour 52minutes |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Working with hours and minutes. Help please!
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany "Chris" schrieb im Newsbeitrag m... I want to draw a graph on something that happened over 24 hours e.g. 0700 2 (i.e. 7am, value - 2) 0713 3 0905 12 1307 2 1906 6 2305 9 (i.e. 11.05pm, value 9) Can I get Excel to put time on the X axis? Can I get Exel to calculate time difference from 7.13am to 9.05am - i.e. it's not 0905 - 0713 = 0202; it should be 1hour 52minutes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working with hours:minutes | Excel Discussion (Misc queries) | |||
| calulate working hours and minutes between 2 dates and times | Excel Discussion (Misc queries) | |||
| =SUM(A1:A5)*24 for totalling hours and minutes is not working | Excel Worksheet Functions | |||
| add hours & minutes to other hours & minutes to receive total hou. | Excel Worksheet Functions | |||
| add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
Linear Mode
