atozcleric

New Member
Joined
Feb 18, 2018
Messages
3
I am working on a spreadsheet and having trouble with the formulas to calculate the times for each of the columns.
I would like to be able to enter the times and have it calculate the rest. I am so frustrated and there has to be an easier way.:confused:

thanks so much.

Date time intime outtotal hours worked Dayshift 0600-1400evening shift 1400-2200Night shift 22-06Weekend Hours Fri 1800-Mon 0600

<tbody>
</tbody>
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

jproffer

Well-known Member
Joined
Dec 15, 2004
Messages
2,647
<b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: center;;">Time In</td><td style="text-align: center;;">Time Out</td><td style="text-align: center;;">hours</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: center;;">7:00</td><td style="text-align: center;;">17:00</td><td style="text-align: right;;">10</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C2</th><td style="text-align:left">=(<font color="Blue">B2-A2</font>)*24</td></tr></tbody></table></td></tr></table><br />


Maybe something like that??
 
Last edited:

atozcleric

New Member
Joined
Feb 18, 2018
Messages
3
thanks so much for the help! i am so frustrated with this sheet I am not sure what I am overlooking.
Thats great but I need to calculate from that the dayshift hours and the evening shift and night shift.
I was trying to use countif formula but I can't get it to work.

Angie
 

jproffer

Well-known Member
Joined
Dec 15, 2004
Messages
2,647
thanks so much for the help! i am so frustrated with this sheet I am not sure what I am overlooking.
Thats great but I need to calculate from that the dayshift hours and the evening shift and night shift.
I was trying to use countif formula but I can't get it to work.

Angie

Aren't all the shifts separated into different sets of cells?

A1 = day in
B1 = day out
C1 = evening in
D1 = evening out
E1 = night in
F1 = night out

If so, you could just use the same formula for each set of cells.

Or it could very well be I'm not understanding what you have going on.
 
Last edited:

atozcleric

New Member
Joined
Feb 18, 2018
Messages
3
Ok, I feel really useless. I am trying to figure these formulas out and watched videos etc.
Here is what I am trying to do.......

Date NAME Location Start Time End Time Total Hours Worked Day 0600-1800Evening 14-22Night 22-06Weekend (Friday 18 to Monday 0600)PTOOT (ANYTHING OVER 40 HRS)
1/1/201811:00 PM7:00 AM#REF!
6:000:00#REF!
7:0015:00#REF!
15:0023:00#REF!
#REF!
Totals

Any other ideas??????

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,263
Messages
5,769,111
Members
425,518
Latest member
seothaeng

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top