View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 1
Default 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