Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Kenneth Bennett on Feb 20 In MS Office Category.

To calculate the time difference between two days

Question Answered By: Luki Fischer on Feb 20

Dim intDiff as integer, strDiff as String

intDiff = DateDiff("n", date1, date2)

strDiff = CStr(Int(intDiff/60)) & ":" & CStr(intDiff mod 60)

Debug.Print strDiff

This Question has 3 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on To calculate the time difference between two days Or get search suggestion and latest updates.

Related Topics:

type casting /converting seconds to a days hours minutes seconds
Time Difference for Page Creation time
Calculating Time in parts of an hour
find the number of working days (monday to firday) between two give
help: Difference between two arrays
Time difference calculations across midnight
Finding difference in time
return time in seconds in VBA?
Time capture of less than one second
Last record is repeated two times
Can't play two multimedias at the same time.
when i press the menu->display time the time must updates every second.
write a program that enters double data into an ArrayList and calculate the total
Calculate Total Sum
How to calculate IRR
Excel won't calculate my function
Easier method to capture & paste calculated value?
Calculating the no. of containers
Calculating duration
Convert string like "=123+456+789" to Long and then calculate

Tagged:to calculate the time difference between two days

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us