ExcelBanter - Hours worked

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Hours worked (https://www.excelbanter.com/excel-worksheet-functions/7129-hours-worked.html)

Keith Bowman

Hours worked

I am trying to get total of hours worked useing military time....

time start time stop total hours
11:34 16:47 =

How do i do this

Jason Morin

Just subtract the two times and format the formula cell as
hh:mm.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to get total of hours worked useing military
time....

time start time stop total hours
11:34 16:47 =

How do i do this
.

LanceB

Assuming your data isn in a2 and b2
=B2-A2
Lance

"Keith Bowman" wrote:

I am trying to get total of hours worked useing military time....

time start time stop total hours
11:34 16:47 =

How do i do this

All times are GMT +1. The time now is 10:36 PM.