split time

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

    Split Time Range into Half Hour Each Row

    I have a data set that look like this Name Activity Detail Start Finish Bob Cooking Cooking pasta 22/04/2020 9:00 22/04/2020 10:00 Bill Reading Reading novel 22/04/2020 9:30 22/04/2020 10:00 And i want to split it like this Name Time Activity Detail Bob 22/04/2020 9:00 Cooking...

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