format time

  1. M

    Simple Data

    I would think this is a simple one but all I want to do is a simple cell format, so that if I type in that cell 0845 it appears as 08:45, in other words just auto insert the colon. All the help I seen to encounter ends up going into time calulations and stuff. I tried the custom format hh:mm and...
  2. A

    Adding Time (minutes) with correct format

    This is my first post and I've read a few other postings about time, but I can't seem to get mine to work. I had the following, which works, but I need to add 15 minutes to the 2nd time (underlined below): If Worksheets("Staffing Comp").Range("D1") = "Friday" Then Sheets("Staffing").Select...
  3. A

    Format a time without entering the :, but keep it as a time

    I have used a custom format so that I can enter a time as 115808 and have it show up as 11:58:08. Unfortunately, now i need to do calculations and the calculations are not correct b/c it is not recognizing this as a time. All of the "solutions" I've found for this don't include the seconds or...
  4. W

    Alternate from timecode to number to timecode

    I'm importing data from Avaya CMS Call Center into excel...I run into an issue when I'm bringing in these kinds of numbers: Total time: 8:46:53 :30:11 :18:37 etc... When they come into excel, I get these values: 31613 1811 1117 etc... If I format the column into any variation of (hh:mm:ss)...

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