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!

Register Log in
  • Congratulations Rhinorhino 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

kevinday1

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

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

cagiv
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sk2107c
  • Locked
  • Question Question
display time with milliseconds
Replies
0
Views
359
sk2107c
sk2107c
Karl72
  • Locked
  • Question Question
Run-Time Translation
Replies
1
Views
316
ShankarJ
ShankarJ
SarjuP
  • Locked
  • Question Question
Calculate Duration of Time for an Employee
Replies
0
Views
158
SarjuP
SarjuP
wchestnut
  • Locked
  • Question Question
TIME function
Replies
3
Views
357
ShankarJ
ShankarJ
SalehKiswani
  • Locked
  • Question Question
Does Timer Affect Performance
Replies
9
Views
597
SalehKiswani
SalehKiswani

Part and Inventory Search

Sponsor

Back
Top