The incoming field will be greyed out as Monarch cannot convert the type on the fly. So you need the calculated field which should be no problem BUT what do you see in Monarch?
If I enter the numbers in the format you posted, whether the Excel field is set to Time or Text, monarch reads it as a Date (30/12/1899) and Time, from which you just want to extract a time field.
If you don't get that what do you get?
If I change the field FORMAT to TIME (from Date) I get 00:21:00 (for example) and I am guessing that your numbers are really 00:00:21 etc, so there will be some work to do perhaps though it may not matter to much if the response times don't exceed a day!
You can convert everything to seconds, but how will depend on what you are seeing in the field.
Edit to correct some terminology.
[size="1"][ January 24, 2007, 07:07 AM: Message edited by: Grant Perkins ][/size]
Thanks for the information, I have converted the time to seconds and averaged it in the summary with a format of 'Time Span' and it's looking good.
Terry /b[/quote]Hi Terry,
That sounds good.
The data I saw from an Excel field defined as TIME described the field as a decimal portion of a day (though still with the question about the hh:mm:ss structure.). Which is what I would expect at that point. So multiplying by an appropriate number (depending on what the fraction is really meant to be) would give the seconds. I guess that is what you have done?
If the field was not an underlying 'fraction' of a day other Monarch functions would be required to convert the text to usable numbers.
Anyway, it sounds like you have a usable result which is the most important thing.