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

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

add a : between your hours and minutes and add the following to the cell
you want to hold the results:

A B C

08:30 23:00 14:30

Formula for C is: =TEXT(B2-A2,"h:mm")

Check out Excel "HELP" it has a lot of info and examples. I used Excel
2003 for this example.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2299525