equation that adds hours as scheduled. 11:00 to 5:00 +6hrs. res.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I sometimes do the employee schedule when my boss is away. The current
schedule is done in excel and is basically a shell with no calculating. I
need a equation for excel that figures Hours worked, for weekly calculation
of payroll. would be easier if excel could compute 11:45 to 5:15 ='s 5.5
hours. Can it or do I need to look to another program.
 
Hi!

A1 = 11:45 AM
B1 = 5:15 PM

=(B1-A1)*24 = 5.5

If the times can span past midnight:

A1 = 11:45 PM
B1 = 5:15 AM

=(B1-A1+(A1>B1))*24 = 5.5

Biff
 
You must log in or register to reply here.

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

Schedule and Timesheet 4
Auto calculating time 1
Formula to calculate hours, and pay 3
Formula to sum based on a change in another column 2
Formula needed for dividing hours by numbers 4
Convert Figure to Time HH:ss 2
Excel Count If Rolling Sum 3
Adding hours scheduled for week 9

Back
Top