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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: optiplex
  • Content: Threads
  • Order by date
  1. optiplex

    Converting "short time" to minutes

    I have used this routine to extract the mins and hours from starttime and endtime: timeused=Format([StartTime]-1-[EndTime],"Short Time") and the result is for example 03:15. How to convert this result into minutes ? /opti
  2. optiplex

    Calculating difference between 2 time fields

    I have 2 time fields(short time) and I like to calculate the difference between them in a third field. I've done two tests: LastTime-FirstTime=1.03 (format of the 3rd field is short time) LastTime-FirstTime=0,04375 (none format of the 3rd field selected) What kind of format must I use in the...

Part and Inventory Search

Back
Top