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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Excel 2013/2016
ABC
1Time InTime Outhours
27:0017:0010
Sheet1
Cell Formulas
RangeFormula
C2=(B2-A2)*24



Maybe something like that??
 
Last edited:
Upvote 0
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
 
Upvote 0
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:
Upvote 0
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>
 
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,342
Members
448,570
Latest member
rik81h

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
Back
Top