|
|
#2
10-08-2023, 03:27 AM
|
||||
|
||||
As per your other thread, the mins calculation is starting at the 4th digit instead of the 3rd, so it was deciding that there were 23 minutes because they were the 4th and 5th digits. Change the 4 to a 3
mins = CInt(Mid(aRng.Text, 3, 2))
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Point out wrong responses (A determined B-D, based on A how to highlight wrong response in B-D) | tdeogburn | Excel | 3 | 01-28-2022 01:07 AM |
| How to set up a timeline with units of 0.1 seconds | gary@gathen.net | Project | 0 | 09-13-2017 10:33 PM |
| Outlook 2013 Messages can sit in the Outbox anywhere from 5 seconds up to 60 seconds | BNS1968 | Outlook | 0 | 09-16-2016 08:07 PM |
 Project 2013 - Issue with Resource Usage showing wrong dates
|
michaelwex | Project | 1 | 02-11-2016 08:41 AM |
| 16 seconds | Scott@Geeks | Word | 0 | 02-24-2009 01:06 PM |
Windows 10 
Office 2016
Threaded Mode