I'm developing a work schedule and would like to use military time.

My first task is to input the "in" and "out" times in military time, noting I will need to use these numbers for calculations. I am trying to avoid using the colon as the extra keystrokes, times 50+ employees, takes up a lot of time.

My second task is to calculate the total hours for the week and display it in decimal format. For example, having the total hours - 4530 displayed as 45.5.

A simple example of this effort is:

In Cell A1 I will place the start time - 0600.

In Cell A2 I will place the end time - 1430.

In Cell A3 I wish to subtract the times - 1430 from 0600 giving me the total hours worked as 830. I would like this number to display 8.5 rather than 830.

I have gone round and round with this and have accomplished portions of it but can't seem to find the right combination of formulas to accomplish everything.

Thank you,

Michael