1. L

    mm:ss formatting

    Does anyone have a solution to formatting mm:ss without the AM/PM after it. I'm creating a spreadsheet where I need to put time as an input, say for a race where something like 10:30 would be 10 minutes and 30 seconds. There are then some calculations done on the time which says if time is below...
  2. H

    Time value to contain Months/Date/Year Hour:Minutes:Seconds AM/PM

    I need time containing Months/Date/Year Hour:Minutes:Seconds AM/PM as shown in I2 with input cells being B2:G2 How to accomplish? I am using Excel 2007 Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col...
  3. A

    Find duplicates as per Date and AM/PM

    Dears, Please help me on this. I want to find duplicates in Column A with Date in B and automatically enter date in Column F with Duplicate no in Column G and Time AM/PM in Column H. And then automatically move to next cell with same date if AM/PM and if not then new Date AM/PM with duplicate...
  4. B

    Coverting 24 to 12-hour with AM/PM Showing

    I have used the formula =RIGHT(A2,8) to extract the 24-hour information 13:00:16 that’s showing in cell B2. I am looking for assistance for the simplest formula available for converting the 24-hour information 13:00:16 in B2 to show a result for 12-hour time with space and AM/PM added at...
  5. D

    Group Time on Pivot Table

    Hi, i have some question. I have row labels on pivot table like this : 1 AM 2 AM 3 AM ... 7 PM Can I change them into this : 1 2 3 ... 19 Or, how to remove/hide that AM/PM. Thanks
  6. S

    Run-Time error 1004 Help

    I used the following vba code to add the date. it is seem to works probably , BUT if i protect the sheet I got the following error : Run-Time error 1004 Unable to set the NumberFormat property of the Range class. Private Sub Worksheet_Change(ByVal Target As Range) Dim i As Integer For i = 4...
  7. W

    Convert Date Format

    Hi in cell b1 I have "Tue, 10 Apr 2018 09:03:05". The only data I am interested in is the time but would like to change it from military time to AM/PM. How can I keep the time only and eliminate all other data? Please help. Thanks! <colgroup><col width="349"></colgroup><tbody> </tbody>
  8. N

    Filtering Time Once Every 6hrs

    Hello, I have data being recorded every 30 seconds, however, I would like to filter it down to once every 6 hours. It's currently displayed in one cell as mm/dd/yyyy hh:mm:ss AM/PM. Any suggestions to how I would go about this? Thanks so much!
  9. M

    Setting time in scatter chart

    Hey! Doing some stuff with charts. Im having trouble getting time to show on Y axis the way I want. My time period starts at 12:17:00 and ends at 7:41:45 - so yes every second and almost 70 000 data points + the 24h format, not AM/PM. I know I have to set the minimum,maximum, major units,minor...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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