Would it not be easier to work with cells defined as [h]:mm:ss, which
would give easy display of recognised time formats, ie :15 (not .25)
for a quarter hour?

This 'improper' time format supports most required functions.

(Just a thought)


srwamp Wrote:
Is it possible to convert regular time into military time. But instead
of
using 60 minutes using 100 minutes. Ex. typing in 14.30 and it changes
to
14.50(which is using 100 minutes.) after you click enter or go to the
next
cell. I use this in my work to help figure easier how many hours my
drivers
have worked.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=486678