colons

I am trying to extract some data from a string of characters. In this example "Invoice: 07022018: 28680: 07/02/2018" I want to extract the 28680 that is between the second an third colons. How do I do that?

3 columns A B C 18:00 19:05 65 (Minutes) Each column is military time and "C" is the total time elapsed in minutes. Is there there a way to automatically enter the colon and still have excel recognize the entry as time? Currently I format...

Hi, I have a sheet where i enter lots of times in the format m:ss.00. I would like to be able to enter these times without the punctuation, i.e. mss00 but still display in format m:ss.00. I'm guessing there is a vba way of doing this (fingers crossed). Any help would be appreciated Thanks, Ross

I am scanning into Excel, computer mac addresses from a bar code. The addresses look like 23e643eea2a6 . I would like to have the addresses formatted to look like 23:e6:43:ee:a2:a6. How can this be done?

Hi all. I need to enter elapsed time data manually into an excel spreadsheet. For example, on paper, I'm looking at this: 125:27:32 I would like to be able to enter this as follows: 1252732 Without colons, to save time. I've searched for many solutions before actually asking, and most of...