Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
Time - Timer and Date Functions
 |
- ADSI - ADSI Time to YmdHms Time
- Alarm Clock Script
- Change Date Time Properties
- Change Regional Long and Short Date Style
- Check for a Valid Date
- Check for valid time input from user
- Convert Seconds to Days Hours Minutes Seconds
- Convert time in seconds to DdHhMmSs
- Convert Unix Time
- Count Number of Mondays In a Month
- Countdown Timer - Dialog
- Current Week of the Year
- Custom Countdown Clock
- Determine the Time Zone I am In
- DST Adjustments for All Windows Computers
- FileTime Discrepancies and NTFS
- FileTime in GMT format
- FileTimeCode and Daylight savings time
- FileTimeGet and TimeStamp in File
- FileTimeSet Function
- FileTimeSetEx January 1 1980
- Find DayLightBias
- Find the day of week
- Finding Average time
- Fixdate with 0 Padding
- Fractional TimeDelay Problem
- Get Clock Speed
- Get day of Year Julian date
- Get Previous Day of Week
- Get Time in Relation to GMT
- GetTickCount
- Highly Accurate Time From Network Computer
- How Many Days in a Month
- How to Get Seconds Ticks Since 1970
- How to Get Server Time
- How to Set System Time
- More Countdown Timers
- Net Time Command Equivalent
- NIST Time Retrieval
- Obtain the Julian day of year and week
- Parsing a Date and FileTimeGet Issues
- Reformat TimeDate for Display
- Rename a File and Concatenate Current Date onto File
- Run Script Once a Day
- Run Winbatch Every Two Weeks
- Schedule to run every hour
- Scheduling with the TimeWait Function
- Script to Launch at the Time of Login
- Sendkey for current date in format MMDDYY
- Set Daylight Savings Time 2007
- Setting Time from Time Servers
- Setting Time Zone
- Sort files by date
- Synchronize Tme between Workstation and Server
- Taskbar Timer
- Time - First Sunday, Last Sunday of Month
- Time Limited Dialogs
- Time Math
- Time Stamp Changes with Daylight Savings
- TimeDelays and Tight Loops
- TimeDiff Unable to Subtract Values
- TimeJultoymd problem
- Timer to Start Every Day or M-F at a Specific Hour
- TimeWait Examples
- TimeWait Scheduling Routine
- TimeWait then Time Sleep for Awhile
- Timing and Wakeup Scripts
- Tomorrows Day of the Week
- Unix standard time calculator
- WinBatch and Daylight Savings Time 2007
- Yesterday Script - Subtract a Day
- ZEN Date Conversion
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Finding 'Average' time
Keywords: Finding 'Average' time TimeJulianDay FileYmdHms
Question:
I hope I haven't overlooked something, but I've scoured the help file pretty thoroughly.I'm trying to calculate the average of a list of time stamps in human readable format (YY:MM:DD:HH:MM:SS).
I tried using a flag file, and setting that file's time in human readable time via "filetimeset", then retrieving the machine readable from "filetimecode" for my calculation of mean. The problem with this work around is that there is no way to get machine readable BACK to human readable...Is there? Any help greatly appreciated.
Answer:
- Use FileYmdHms
- Use TimeJulianDay to convert to a Julian date
(if interested in longer spans of time.
or use TimeDiffSecs to convert to seconds from some standatd point in the past.
- Average the numbers.
- Use TimeJulToYmd to convert back to a standatd format date, ot TImeAdd to regenerate a standard datetime (thi sone is tricky)
Article ID: W15721
File Created: 2003:05:13:11:29:50
Last Updated: 2003:05:13:11:29:50