time calculations

  1. B

    Time cell does not add correctly

    Good morning all, I am trying to add the values in cell H73 (see below), but what I get is not correct. In this cell H73, formatted as Time, I have this very simple formula: =H14+H28+H42+H56+H70 <TBODY> G H 68 Total Hrs. worked 9:00 69 Total min. Travel Time 1:00 70 Daily total 10:00...
  2. B

    Adding times

    Hello everyone, I am trying to help my wife with a schedule she is making, but all attempts at adding times have gone the wrong way. Let me explain what I need to do. Let say that in cell A3 I have a start time of the format e.g. 10:30, and to this I would like to add 3.5 hours. What I need to...
  3. R

    Time Calculation Problems: AVERAGEIFS for data inclusive between certain times, which may cross over midnight, duration may result in a negative numbe

    Good afternoon, I am trying to get the average time it takes for employees to be ready/available for their shift, with a separate column showing the duration (minutes and seconds) since some people understand that better. However, anything over 20 minutes before or after the shift begin time...
  4. L

    time calculations in excel

    Hey guys, thanks in advance for your time and the potential solution.... how do you subtract and add time past 24hrs example A1 B1(no. of hours to subtract) 00:00 3 answer = 19:00 Example 2 A1 B1(no. of hours to add) 00:00 3 answer = 03:00 Example3: 12:00 + 4...

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