Thank you oldchippy and daddylonglegs both versions worked like a charm
I have one issue I need resolved now that I forgot to orginally mention
If my time falls on a new day the calculations that you provided don'
work correctly. The calculation would provide a negative number sinc
B1 appears to be a lower number than A1, but actually its just the nex
day. Example:
A1 = *2330*
B1 = *0140*
C1 = *2.2
--
azdp
-----------------------------------------------------------------------
azdps's Profile:
http://www.excelforum.com/member.php...fo&userid=3719
View this thread:
http://www.excelforum.com/showthread.php?threadid=56911