Convert date range to hours/minutes 1

[dimsis]

I need a function when you pass two dates (start and end date), it will return the hours and minutes passed in the hh:mm format.

TIA

 

[HarleyQuinn]

Look into DateDiff().

You can retrieve the difference in minutes and then convert them to hours and minutes.

Harleyquinn

---------------------------------
For tsunami relief donations

 

[johnwm]

Just subtract and use the Format function:

strDuration = Format(dtNewtime - dtOldTime,"hh:nn:ss")


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

For tsunami relief donations

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts