Time difference

[Rafael44]

Hello

Given time1 and time2 date variables which contain time values, how can i calculate date2-date1 and get the value in hours within a macro only.

Thanks
Rafael

 

[plettieri]

I guess you have a need to perform this in a macro, but understanding how Excel deals with time, date, etc is helpful ...see...http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

Also thread posted for some help http://216.92.17.166/board/viewtopic.php?topic=25169&forum=2


hope this helps

pll

 

[Rafael44]

Hello plettieri

I'm afraid that i need to do it in a macro only (now i use formulas in the worksheet)
so i can use the function in other workbooks.

i tried the following line in vb:
f=formatdatetime(date2-date1,vbshorttime)
and then i got the difference in time format (00:30) but how can i convert the time value to integer (0.5)?

Thanks
Rafael

 

[Andrew Poulsom]

Subtract date1 from date2, multiply by 24 to get hours and format as 0.0.

 

[plettieri]

By converting the answer to a general number will allow for a true integer answer

Selection.NumberFormat = "General"

hope this helps

pll

 

[Rafael44]

Thank you it worked