Times in XL are just numbers - calculated as fractional days, so 6:00 =
0.25. I'm not sure how you're "figuring" elapsed times, but if you
format your cell the same way your TEXT() format string does, it should
work fine as numbers. To display elapsed times 24 hours (XL by default
"rolls over" the display) use

Format/Cells/Number/Custom [h]:mm

See

http://cpearson.com/excel/datetime.htm#AddingTimes

for more.


In article ,
"lylehughey" wrote:

They are figured using TEXT, it is the only way that i could get it to figure
elapsed time, if you can point me in a different direction please do so. At
this point any help is greatly appreciated. Thanks again