hours mins separate time

  1. E

    Hours and Minutes between two dates and times

    Hi, I am after a formula or VBA, which works out the total hours and minutes between two dates and times: i.e. A1: 11/11/2014 21:00 A2: 12/11/2014 06:00. Essentially I need the total hours and minutes between Cells A1 and A2. Excel has difficulties with 24 hour periods and formulas I have...
    • Ebusua
    • Thread
    • date and time format hours mins separate time
    • Replies: 3
    • Forum: Excel Questions
  2. E

    Help with Complicated time calculations- Separating hours and minutes

    Hi, I have a calculator I'm working on in excel to calculate a figure from an hourly rate. I have a cell which adds up the sum of the total minutes in column b. I have another cell which converts this to hours and minutes by using C19/1440 I need to be able to do a calculation for the whole...

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