decimal time

  1. S

    Subtracting Decimal Time (4.3 minutes) from time value 10:00 am

    I have the following values that are exported out of Epic EMR (electronic medical record). The first column is a decimal time value, for example the first example is 4.3 minutes. I want to subtract the 4.3 minutes from the time stamp of 10:01 am in the second column. I realize I could manually...
  2. T

    How do I change 8.30 to 8:30 please?

    I have a spread sheet full of start & finish times that are in decimal (8.30am) format that I need to change to 8:30 so that I can use a formula to calculate the worked hours. Start 8.30 Finish 12.13 Total Hours 'x' Thanks Tammie

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