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 TouchToneTommy 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: *

  1. fennerhillpro

    Need to find average of datediff and display in HHMM

    I am a Newbee and working on Ver 9. I need to get the time diff between time in and time out which the formula below works fine for. However, I also need to find the aveage and mean times and display and since they are a string I can't. I can display in sec or Min (by adding /60) but Icannot...
  2. fennerhillpro

    The must be an easier way to do this

    I am working on a database that has errors in the time. Time is recorded in Military time (1059). However, I keep getting error because people have entered 1095 ect. Insted of doing 24 if then statements how can i do one that says if the last to digits are >59 then put in 30 so 1095 would...
  3. fennerhillpro

    Still not getting how to convert seconds to hours and minutes

    I am a newbee with Crystal and can't figure how to convert the formula below to HH:MM time(int({ERLOG.DTIME}/100),remainder({ERLOG.DTIME},100),0) - time(int({ERLOG.ATIME}/100),remainder({ERLOG.ATIME},100),0) I get out put of 10,200.00 what I want to see is: 2:50 or 2hr 50 min Can anyone...
  4. fennerhillpro

    Subtracting Discharge time from Admit time

    I had to convert time from a # and I used this formula: time(int({table.timeint}/100),remainder {table.timeint},100),0) Now I need to subtract the time a patient was discharged for the time they came in. Example: Admit Discharge Should = 7:50am 10:40 2:50...

Part and Inventory Search

Back
Top