Hi!

If you enter the time as true Excel time:

A1 = 6:00
A2 = 18:00

=A2-A1+(A2<A1)

Format the cell as [h]:mm for a result of 12:00

=(A2-A1+(A2<A1))*24

Format the cell as GENERAL for a result of 12

Biff

"Kyle Sweeney" wrote in message
...
Can anyone help me with this.

I want to add 2 cells time (military time) and convert it to hours. This
is for a payroll system. Saying we are using the following setup:

A1= 0600
A2= 1800
A3= ????

Where A3 is the total hours worked

Thanks