LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 17th 20, 11:22 AM posted to microsoft.public.excel.programming
external usenet poster
First recorded activity by ExcelBanter: Mar 2020
Posts: 37
Default Converting a Number to Time

Hi Team

In an effort to speed up data entry, I would rather the user ( namely me at this point ) be able to add a number and have it converted to it's time equivalent:

So, if I enter:
515. Convert it to 5:15
1415. Convert it to 14:15, etc.

I would like to insert into my existing Worksheet_Change code:
If Not Intersect(Target, Range("C3:C43")) Is Nothing Then
If Target.Cells.Count 1 Then Exit Sub

Select Case Target.Column
Case 3
If Target.Value = "YARD" Or Target.Value = "C0654" Then
Target.Offset(0, 7).Select
Target.Offset(0, 1).Select
End If
Case 8
Target.Offset(0, 2).Select
Case 10

Target.Offset(0, 1).Select
End Select
End If

I found the following code, which does what I need if I trigger it manually, but won't trigger inside the Change Code.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting Time in a number Soccerboy83 Excel Discussion (Misc queries) 1 September 17th 09 07:11 PM
Converting time to number, i.e. 2:32 to 2.32 Kokomojo Excel Worksheet Functions 7 April 23rd 09 10:23 AM
Converting Time to a Number Connie Excel Discussion (Misc queries) 3 August 4th 08 05:40 PM
converting number to time bourbon84 Excel Discussion (Misc queries) 3 August 21st 06 10:32 PM
Converting whole number to TIME B. Baumgartner Excel Discussion (Misc queries) 3 July 1st 05 11:26 PM

All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017