Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time interval worksheet function
I would appriciate some help writing a function, to measure several interval
along a timeline. however not every interval applies to every record. what I envision is a function that takes 7 arguments a. start time (there may be 1 to 5 times) b. a way to indicate wether I want the min or max time c. a high and low out range value d,e & f. End time same 3 critera as start time g. format choice for [h]:mm, just minutes or h.00 I currently use =IF(MIN(Data!G2,Data!H2,Data!I2,Data!P2)-Data!B27,"OVER",IF(MIN(Data!G2,Data!H2,Data!I2,Da ta!P2)-Data!B2<0,"",MIN(Data!G2,Data!H2,Data!I2,Data!P2)-Data!B2)) but this doesn't really do all I need it to and is very time consuming. I do to this to log times for an Emergency Dept's visits so it needs to be done on a regular basis and the looked at intervals change regularly so I just can't use a template. Any and all help would be truely appriciated Thanks Zb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
request for time interval worksheet function | Excel Discussion (Misc queries) | |||
Excel to recalculate a worksheet based on a time interval | Excel Worksheet Functions | |||
Calculating time interval (some across midnight) | Excel Worksheet Functions | |||
Calculations with date time interval | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) |