Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time durations in excel and VB
I'm using VBA for excel. A formula in a cell calculates the timespan between
two date/times in minutes. I need to extract this number from excel into VB, but it always converts the number to the date/time serial number! any help appreciated - this should be easy! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time durations in excel and VB
Time is held in Excel as a fractional part of 1 day. So if you declare a
variable as Double, you should be able to get it quite easily as a number Dim myNum As Double myNum = Range("D1").Value MsgBox myNum -- HTH RP (remove nothere from the email address if mailing direct) "Owen" wrote in message ... I'm using VBA for excel. A formula in a cell calculates the timespan between two date/times in minutes. I need to extract this number from excel into VB, but it always converts the number to the date/time serial number! any help appreciated - this should be easy! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How enter time DURATIONS mm:ss (not clock times), then sum? | Excel Worksheet Functions | |||
Adding time durations | Excel Discussion (Misc queries) | |||
formula for negative time durations | Excel Worksheet Functions | |||
Adding up time durations? | Excel Discussion (Misc queries) | |||
How do I calculate time durations over numerous dates | Excel Worksheet Functions |