need to convert from one time expression to another

[evilyn]

i get data from a billing system that stores time like 1:50 (which
means 1 hour & 50 minutes) but i have to put it into a database that
wants the time to be 110 minutes. the information that i get comes as
a delimited text file that i open in excel clean up (i love macros) &
then import into an access database. every month some one did the
math to convert the time but i think there has to be a better way.

any & all suggestion/ideas/help is appreciated.

 

[Niek Otten]

=A1*24*60, Format as General or Number. (not Time, which is what Excel does automatically)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|i get data from a billing system that stores time like 1:50 (which
| means 1 hour & 50 minutes) but i have to put it into a database that
| wants the time to be 110 minutes. the information that i get comes as
| a delimited text file that i open in excel clean up (i love macros) &
| then import into an access database. every month some one did the
| math to convert the time but i think there has to be a better way.
|
| any & all suggestion/ideas/help is appreciated.

 

[evilyn]

AWESOME!! thank you so much!