Thanks David....already tried as you suggested, however forgot about the
"[h]" part. Worked perfect. Thanks again.

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
If you have the date and time information together in the cells (such as
04/02/2008 07:20 and 05/02/2008 14:45), then instead of MOD(S50-N50,1)
you just want S50-N50.
If you don't have the date with the time, you just need to add 1 to the
result if you've got an extra day.

In either case, format the result as [h]:mm, not as h:mm
--
David Biddulph

"Meebers" wrote in message
...

"Meebers" wrote in message
...
I am trying to figure out how I can subtract 2 times: day 1=7:20 am and
day 2 = 14:45 answer should be 31:25. I need to use the result when
averaging the column. Formula used is :
=IF(COUNT(N50,S50)=2,MOD(S50-N50,1),"") giving me 7:35 which would be
correct if within 24 hrs. TIA oops typo should be 7:25