Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to handle tdate and time
I am storing two dates and times as a text value ie.
"24/12/2009 23:54" & "25/12/2009 00:23" I need to evaluate the subtraction of these two values that are stored as text ( I need to secure they do not revert to a mm/dd/yyyy format (which they do despite my many efforts) when I sort) .... anyway.... I need the value as per example above to give me the result in hh:mm format.... 00:29 (29 mins) I need to do the calculations in VBA I have tried using DateValue and TimeValue in various arrangements but can't seam to find the magic words.... do I need to split date and time and evaluate or can I use the combined date and time in a subtraction formula? Any help appreciated just to set me on the right path. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you format time to handle microseconds | Charts and Charting in Excel | |||
what is "fill handle". i don't see any fill handle in my excel | New Users to Excel | |||
How can I handle negative time values? | Excel Worksheet Functions | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
How do I handle #Value in VBA? | Excel Programming |