Hi

Time is stored in Excel as fractions of a day.
Multiply your time value by 24, and it will turn to decimal so 14:30 will be
14.5


Regards

Roger Govier


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.