spread sheet excel for payroll I can put hrs in and get totals

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

Guest

I would like to created a simple spread sheet in excel that I can put clock
in hrs &clock out hrs and get a total
 
A B C
Time In Time Out Hours
22:00 06:30 8.50 '<== row 2
09:00 17:00 8.00

Cells in columns A &B are formatted as hh:mm

Formula in C2 is:

=(MOD(B2-A2,1)*24)

which allows for working over midnight.

Cell formatted as Number with 2 dec places

Copy down as required.

HTH
 
I would like to created a simple spread sheet in excel that I
can put clock in hrs &clock out hrs and get a total
Click to expand...

If your "Time In" is in column A and your "Time Out" is in column B, both
starting in row 1 for this example, then put this in C1

=MOD(B1-A1,1)

and copy down for as many rows as you have data.

Rick
 

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 ROUND 37.75 UP TO 38 OR DOWN TO 37.5 FOR PAYROLL 4
Macro / function text time to 24hr excel time passed midnight fortotaling hr's 2
multiply criteria in a range using sumifs 1
Annual Wages Sheet to pick up info from Time Sheet 2
sumif formule using headers as criteria 2
Need formula to prevent typing in duplicate numbers 1
What equation will total number of cells with specific words? 3
Time Sum in Excel 1

Back
Top