Calculate time

Excelexcel86

Board Regular
Joined
Feb 28, 2023
Messages
99
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Hi guys quick question how do I calculate time but only first 6 hours from two dates like so

02/03/2023 10:30 02/03/2023 15:30.

Obviously if I just minus the two cells I get 5 hours but I need it to stop calculating anything after 12:00 on the same day so it should be 1.30 hours

Any help be much appreciated
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
I cannot get data out of a picture. Please help me help you. Please use the xl2bb add or post a table.
use this tool to post a table:
1677744172112.png
 
Upvote 0
I cannot get data out of a picture. Please help me help you. Please use the xl2bb add or post a table.
use this tool to post a table:
View attachment 86577
Start timeend timeTimes between hours workedTimes after hours worked
16/02/2023 11 :3516/02/2023 12.50
16/02/2023 08:4017/02/2023 05:55 Should be 5.50Should be 20.55
17/02/2023 10.3017/02/203 15:30Should be 1:30 as it’s a FridayShould be 3:50
 
Upvote 0
Start timeend timeTimes between hours workedTimes after hours worked
16/02/2023 11 :3516/02/2023 12.50
16/02/2023 08:4017/02/2023 05:55Should be 5.50Should be 20.55
17/02/2023 10.3017/02/203 15:30Should be 1:30 as it’s a FridayShould be 3:50
The issue is I have aster time of 06:00 and finish time of 14:00 and on Fridays it is 06:00 to 12.00 so the hours that are worked are 8 hours and 6 for Friday.

Some days the dates and times go over 24 hours

So I need a formula that’s calculates the hours worked and the times after it passes 14:00 and 12:00 in the afternoon
 
Upvote 0
Do you need to deduct Lunch Breaks or not ?
 
Upvote 0
what do these phrases mean:
Times between hours workedTimes after hours worked
 
Upvote 0
what do these phrases mean:
Times between hours workedTimes after hours worked
That’s just cell name for where the results go so when new dates get entered into the first 2 cells I can just drag these down with the formula created to calculate the results
 
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,337
Members
448,568
Latest member
Honeymonster123

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