12 hour format

  1. S

    Calculating Time Units - VBA User Form

    I have code that will calculate time elapsed and how many 15 minute units are between the two times entered. It was later decided that an user form may be the more appropriate approach for my audience but I have 0 experience with user forms. I made an attempt but I can't figure out how to make...
  2. S

    number string to time with am/pm

    How do you convert 01241 to 1:24 am - hh:mm 1 for am 2 for pm 01241 (hhmm#) to 1:24 am - hh:mm 1 for am 2 for pm 02452 (hhmm#) to 2:45 pm - hh:mm 1 for am 2 for pm 12142 (hhmm#) to 12:14 pm - hh:mm 1 for am 2 for pm 08451 (hhmm#) to 8:45 am - hh:mm 1 for am 2 for pm I want to have data entry...

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