How to calculate working and non working hours and return them in hh:mm:ss

M

MoonLove

New Member
Joined
Dec 31, 2022
Messages
42
Office Version
  1. 365
Platform
  1. Windows
Hello Team,

Iam looking for a formula to calculate working and non working hours then should be returned in form of hh:mm:ss.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Sort by date Sort by votes
what are the time frames you want examined? Do you have a start and end date/time? What is your definition of a working hour? Do you count weekend hours? Any other specific rules for your particular situation?
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
calculate Turn Around depending working hours, break and holidays but include outside working hours
Replies
0
Views
138
ClaudiaMS
C
I
  • Solved
Calculate total hours into days, hours, minutes
Replies
3
Views
415
Issie_52
I
Sh8dyDan
  • Solved
Is it possible to use IF function inside the Conditional Formatting formula?
2
Replies
15
Views
563
SanjayGMusafir
SanjayGMusafir
S
  • Question
Calculate Turn Around Time 7 days working excluding Holiday and in Working Hours
Replies
3
Views
507
surevyas1984
S
A
  • Solved
Production time calculation within the working day accounting for breaks
2
Replies
16
Views
713
felixstraube
F

Forum statistics

Threads
1,215,200
Messages
6,123,601
Members
449,109
Latest member
Sebas8956

Share this page

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