Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

time

Status
Not open for further replies.

kevinday1

Programmer
Mar 30, 2013
4
US
I have 2 time variables eg 20:20 and 08:30 how do I find out how many mins in between cheers
 
In your case:

ROUND((DEFORMAT('20:20',@T1) - (DEFORMAT('08:30',@T1) + 8640001))/(-6000),.01)
-> 730 min

cagiv
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top