I have two comments about your request

1) Do you want the return value to be in Microsoft time format or a string.
A function cannot control the format. if you have the actual time returned,
then you must format the cell to get your preferred formatt. You can have
the function return a string instead of time in two differentt formats.

2) You can't have a function with two diffferent parameters havving multiple
lengths. Can you specify a range of cells for the start and end times?

"Zb Kornecki" wrote:

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