Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-19-2021, 03:13 PM
Guessed's Avatar
Guessed Guessed is offline VBA Help with Time am/pm Format Windows 10 VBA Help with Time am/pm Format Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

That changes things a bit. I've modified the earlier searches and added a new section at the end
Code:
Sub DPU_TimeFormat2()
  Dim Rng As Range
  Application.ScreenUpdating = False
  Set Rng = ActiveDocument.Range
  With Rng.Find
    .MatchWildcards = True
  
    'Delete periods in a.m./p.m.
    .Text = "([APap]).([mM])."
    .Replacement.Text = "\1\2"
    .Execute Replace:=wdReplaceAll
    .Text = "([APap]).([mM])"
    .Replacement.Text = "\1\2"
    .Execute Replace:=wdReplaceAll
    
    .Text = "([0-9]) ([APap])([mM])>"     'without space between number and a/p
    .Replacement.Text = "\1\2\3"
    .Execute Replace:=wdReplaceAll
    
    .Text = "([0-9])AM>"                  'AM to am
    .Replacement.Text = "\1am"
    .Execute Replace:=wdReplaceAll
    .Text = "([0-9])PM>"                  'PM to pm
    .Replacement.Text = "\1pm"
    .Execute Replace:=wdReplaceAll

    'Change period for colon in times
    .Text = "([0-9]{1,2}).([0-9]{2})([ap])m"
    .Replacement.Text = "\1:\2\3m"
    .Execute Replace:=wdReplaceAll
    
    'Expand abbreviated hours
    .Text = " ([0-9]{1,2})([ap])m"
    .Replacement.Text = " \1:00\2m"
    .Execute Replace:=wdReplaceAll
    
  End With
  Application.ScreenUpdating = True
End Sub

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Last edited by Guessed; 10-20-2021 at 01:46 PM.
Reply With Quote
  #2  
Old 10-20-2021, 08:11 AM
Shelley Lou Shelley Lou is offline VBA Help with Time am/pm Format Windows 10 VBA Help with Time am/pm Format Office 2016
Expert
VBA Help with Time am/pm Format
 
Join Date: Dec 2020
Posts: 259
Shelley Lou is on a distinguished road
Default VBA Help with Time am/pm format

Andrew, thank you so much for the updated code, it works perfectly. I initially searched the internet high and low for something like this but there was nothing at all for Word documents so hopefully this will benefit someone else looking to format times in documents. Thank you again for you help and patience as ever, best wishes, Shelley
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Format number for time , hh:mm:ss,,,second appears 00 yoshi Excel 4 04-26-2021 03:11 AM
VBA Help with Time am/pm Format How to set the table cells as time format? jiaron_1230 Word VBA 3 11-15-2016 05:15 AM
VBA Help with Time am/pm Format Changing Date/time to Australia format tmeck63 Project 1 01-07-2016 09:11 PM
time in minute format orajesh Excel 3 12-15-2015 12:56 AM
Changing format of time data Sammael Excel 2 04-08-2012 12:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft