Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
2007 VBA Duration format
At this time, I'm not returning the number to a cell, but directly to a chart. I've a two dimensional array(1 to ?, 1 to 1) I send to the Excel Chart to populate the data. I may need to in order to correctly represent the hover over points. gulsbyd- gulsbyd
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
2007 VBA Duration format
I understand Time in VBA is a double. Whole number being days and fractions being hours/minutes/secs. Example 1.3 = 31 hours 12 minutes 00 seconds. What I am trying to do is chart this as 31:12:00, but the best I've been able to do is send "31:12:00" to an Excel Chart which isn't chartable due...- gulsbyd
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
