To calculate the working hrs of employee in excel

P

pol

I have an excel sheet with opening hrs and closing hrs of the business . Then
Inhave to find out the working hrs.

A1 cell contain opeining hrs and B1 cell contain closing cell

A1 cell value = 8.50 AM
B1 Cell value = 17.40 PM.

Please hw I can find out the working hrs as 8.40 .

with thanks and regards
Pol
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To find out the total number of hrs worked in a week 2
Calculate OT/TIL hours when 1st 2 hrs are double time, rest are 1: 2
Calculate Total hours worked during workdays within given shift time. 2
Relating One cell Value to another to the left of it. 2
to replace a value in each cell of the column 12
How to give find function ( same as of ctrl F) in formula bar 3
Employee time sheet 1
To execute a formula upto in a cell 3

Top