Entering time using decimal place or Colon

**Mira Sheridan** · 02-07-2012, 11:17 AM

Hi folks,

I did a search on here and found some code that does what i want (mostly) which is to allow users to enter a time in either 7.3 or 7:30 and have it display as 7:30. Except it doesn't work if some one enters a time less than 1 for expamle enters 0.3 (meaning 0:30) it shows 7:12

Please Login or Register  to view this content.

I have tried changing the code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

but then it will not acept time entered with a colon.

Can anyone help me, what do i need to change?

I'm using excel 2003

Thanks, Mira.

**Bob Phillips** · 02-07-2012, 11:27 AM

That look suspiciously like my old code.

Anyway

Please Login or Register  to view this content.

**Mira Sheridan** · 02-07-2012, 11:40 AM

Originally Posted by Bob Phillips

That look suspiciously like my old code.

That cos it was your code i found

That fixes the 0.3 problem but now if you try and enter 1:00 it changes it to 0:04 instead of leaving it as 1:00

Any sugestions?

Thanks, Mira.

**Mira Sheridan** · 02-08-2012, 07:37 AM

I forgot to say I know nothing about VBA so I am unable to diagnose the problem my self.
Any help is much appreciated

Mira.

**Mira Sheridan** · 02-22-2012, 12:09 PM

Bump.
I'm still searching for an answer to my problem

Any help much apprectiated and maybe even see my way clear to paypal'ing a few beer tokens to the person who can solve my problem

Thanks, Mira.

Entering time using decimal place or Colon

LinkBack

Thread Tools

Rate This Thread

Display

Entering time using decimal place or Colon

Re: Entering time using decimal place or Colon

Re: Entering time using decimal place or Colon

Re: Entering time using decimal place or Colon

Re: Entering time using decimal place or Colon

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions