Dear all,
I'm trying to write a code to map time values to a specific Time Category, as shown below, but in vain.
Time Time Category 20:05:00 8 PM to 9 PM 11:59:00 11 AM to 12 PM
I've attached the code. Perhaps, it's something to do with formatting.
Appreciate any help on the same.
Thanks,
Vinod Krishna
Try this formula
Formula:
=TEXT(A2,"h AM/PM to ") & TEXT(A2+TIME(1,0,0),"h AM/PM")
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Or this VBA code
Do Until IsEmpty(ActiveCell) ActiveCell.Offset(, 2).Value = Format(CDate(ActiveCell.Value), "h AM/PM to ") & Format(CDate(ActiveCell.Value) + TimeSerial(1, 0, 0), "h AM/PM") ActiveCell.Offset(1, 0).Select Loop
Thanks a lot AlphaFrog. Most efficient code and works like a charm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Vinod Krishna.C 
Register To Reply
Bookmarks