ExcelBanter - Time format

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Time format (https://www.excelbanter.com/excel-programming/424853-time-format.html)

Joe Wildman[_2_]

Time format

Hello everyone, I am unable to get the code right
I have a cell in VBA called "date_time", it is formated to be "mm/dd/yyyy
HH:MM"

In the output email it paste into it shows the the seconds so i did some
code and was unable to get it to work in the correct format

Call Date_Time (works) but shows seconds
or
Call Date_Time .... "mm/dd/yyyy HH:MM") ...not working

Billy Liddel

Time format

Joe
Try
With Date_Time
.Value = Now()
.NumberFormat = "MM/DD/YYYY hh:mm"
End With

Regards
Peter Atherton

"Joe Wildman" wrote:

Hello everyone, I am unable to get the code right
I have a cell in VBA called "date_time", it is formated to be "mm/dd/yyyy
HH:MM"

In the output email it paste into it shows the the seconds so i did some
code and was unable to get it to work in the correct format

Call Date_Time (works) but shows seconds
or
Call Date_Time .... "mm/dd/yyyy HH:MM") ...not working

All times are GMT +1. The time now is 04:53 AM.