Check my October, 2003 Access Answers column in Pinnacle Publication's Smart
Access.
You can get the column (and accompanying database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Mike" wrote in message
...
In MS Excel I convert a cell that contains the following into minutes:
1d 01h 12m would convert to 24.2...
The code is:
=IF(iserror(FIND("d",E2)),0,LEFT(E2,FIND("d",E2)-1)*24)+MID(E2,FIND("h",E2)-2,2)+MID(E2,FIND("m",E2)-2,2)/60
Is there a way for Access to convert d h m into hh.m?
Thanks,
Mike