calculate hours

  1. G

    Convert time

    Hello. I have a sheet that utilizes time in 24hr format. There are some time calculations that result in how many hours an employee has left to work, and displays it in the 24hr format. Is there a way to split the value and add text to have the cell show "11hrs 30 mins" rather than "11:30"...
  2. F

    Calculate band on Hours/Time passed

    Please help me out to figure out a formula to calculate Date/Time Base Bins (See attached Image).Whenever The ID Creation(Column A) on Current Day and Time 3:00 PM to 6:00 PM, In Column C "> 3 to 6 PM" , Current Date and time between 6 to 7 PM in Column C result should be " > 6 to 7 PM", after...
  3. S

    need help to count hours from a calendar schedule

    i need to get a total of hours from cells in a continuouscalendar type of sheet. sheet setup:dates across the top(row 1) and equipment on the left(col A, frozen). basically the body of cells have informationon what is going on for each equipment on the left under the date in the toprow...

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