1. V

    Miuns Non Working Hours

    I have this problem, here. Now in a column A I have the End time and in column C in have the start time. Am bit confused with the non working hours From Sun to Thu it is 13:00:00 hrs -- Non working hours On Friday it is 15:00:00 hrs -- Non working hours On Saturday it is 12:00:00 hrs -- Non...
  2. D

    Hours zero display

    I am trying to have a hour displayed as 15 hrs not 015 hrs. Cell I 10 in Text format 10-11-2019 3:48 PM Cell L 10 in Text format 10-12-2019 7:38 AM Formula in M 10 INT(L10-I10)&TEXT(L10-I10,"h"" hrs ""m"" mins """) it returns the answer of 015 hrs 50 mins. I am...
  3. L

    subtract time

    Hi I want to find how many hours a user worked. The start time was A1= 10:00 pm and shift finished B1=1:00 am, so this user worked 3 hrs, so when I did C1 = 24 * (B1-A1) I got ################....... How that can be fixed. Thank you very much
  4. P

    Working hrs. Minus breaktime (8hrs/day) from range of days

    Work Start: 8:00 am Work End :5:00 pm Break Start: 12:00 pm Break End:1:00pm I am trying to compute the working hours with raw data like 08/30/2019 4:00pm - 09/02/2019 9:00am. The result in this one should be 2 hrs only. But if the raw data is 09/02/2019 8:00 am - 09/02/2019 9:00am result...
  5. P

    Time to Number Convertion help.

    How to convert 13:10 (13 hrs. 10 mins) into 13.7 (number)?
  6. A

    Formula calculates working hrs.

    =IF(COUNT(E3:F3) = 2, MOD(F3-E3,1)-"8:00", "") Hello, The formula given above calculating the extra hrs after 8 hrs. Is there any way to change it if there are entries below 8hrs the formula will give me the negative result? Sample 14:00 => 01:00 = 3 14:00 => 21:00 = -1 Many Thanks
  7. P

    Working hrs. computation

    I am trying to create a report where working hrs. is computed. Ex. 8/30/2019 4:00 PM - 09/02/2019 9:00 AM Working hrs. 8 am - 5 pm I want to have a result of 2 hrs. Since worked it done in 8/30/19 4-5pm and 9/2/19 8-9am only. 8/31/19 & 9/1/19 are weekends. Also I want to exclude hrs in night...
  8. M

    Calculating elapsed hours with weekends.

    I'm trying to calculate elapsed time in hours from a start date/time to an end date/time. Work hours are M-F, 6AM - 6PM. Below is the formula I'm using. =(NETWORKDAYS(B3,C3)-1)*("18:00"-"6:00")+MOD(C3,1)-MOD(B3,1) The problem I'm having is if the start day is after business hours or on...
  9. M

    Items picked per partial hrs not full hrs ( items / time)

    Hi I'm using excel 2016, with data running down the columns Q,S,T it calculates items divided by hrs, but I'm stuck as i have partial hrs and this over inflates the value in T1, is there anyway i can make it more accurate say to the nearest 15 minutes also how do i remove #DIV/O! as my...
  10. P

    Hrs & Duration

    Trying to capture time, elapsed time, duration however you want to look at it. I want to be able to enter it to the nearest 1/4hr 4 hrs 00 min 4 hrs 15 min 4 hrs 30 min 4 hrs 45 min I'm not able to get this to work correctly.
  11. C

    looking for a simple solution

    I am building a rota and so have 52 work sheets titled week1, week2, etc... each sheet is identical in layout, similar to below. Assume that cells here run from A1:O5 What I want to do is have all the dates update across the 52 sheets when I enter the 'start' date in week1 Currently I am just...
  12. N

    Help with Vacation Spreadsheet

    I have a main worksheet that draws info from another worksheet called vacation. Vacation has the amount of vacation time in hours the employees get each year and also vacation carried over from previous year. Main worksheet has 31 employees and their attendance for each month in 12 tabs (each...
  13. A

    hrs. and min. between two times

    <tbody> 2:00 PM 1:25 AM 3hrs.25min. </tbody> Hello, Could you help me with above sample. I need a formula to show total hrs. between 2 times after 8 hrs extra working Many thanks
  14. M

    Trying to Perfomr Data valaidtion if # exceeds value in other cell.

    <tbody> A B C D E F 1 This Wk Hrs Worked Prev Wk Hs worked Prev all Hrs Worked Estimate hrs cumulative hrs New Total Hs 2 2 4 5 10 9 (sum b:c) 11 3 4 </tbody> Trying to understand how I can perform data validation if exceed value in...
  15. M

    Lost my mind - I don't know where it fits, please read and help if you can

    OK, so I am trying to perform an action on Hours:Minutes in which climb higher every day. What I am trying to accomplish is better shown than to use words, but I will try both. Ok, so in words, I drove a total of 110 hrs and 30 minutes (110:30) thus far. On Monday, if I drive 5 hrs and 30...
  16. A

    Calculating double time after 8hrs

    Hello I could really use some help completing this formula. I recently realized my worksheet has not been adding double time hrs. correctly. In California DT is pay on two occasions For all hours worked in excess of 12 hours in a workday. And for all hours worked over eight(8) on the seventh...
  17. T

    Convert Hr M to time

    Hi I have the following information of contractors of internal and external staff and when the sheet comes to me i get thousands of lines but i need to total the columns up into Days, Hours,Minutes but i need a little help with converting the cells because there is so much i need to change the...
  18. T

    Sum Data based on Multiple Conditions across Multiple Sheets

    <tbody> Code # 1 thru 10 Hrs 1 Hrs 2 Hotel Meals Misc Miles </tbody> Based on the Code # I need to be able to total Each of the other data across multiple sheets (50+). Each Sheet contains a group of 6 entries of the data as shown.
  19. V

    Add values where text equals something

    hope someone can help. So i have an excel timesheet output. Some spots in the excel it will show like this 6 Hrs Straight / 2 Hrs PTO or just pto like this 5 Hrs PTO or maybe no pto. So basically i want to add up pto value in the entire sheet the value wherever it is "x Hrs PTO" thank you...
  20. N

    TimeSpans -Splitting Hours

    New Member - first time post - Hello all, Does anybody know how to calculate the following- (A1)Start 25/11/2018 17:00 (B1) Finish 26/11/2018 10:00 - Total Elapesed Time = B1-A1 = 17 HRS The elapsed time between the start and finish is 17 hrs - however is is split over two days What...

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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