It works great... Thanks Julie!!

"JulieD" wrote:

Hi Mike

try
=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

Cheers
JulieD

"Mike" wrote in message
...
My data has days hours minutes in cell E2. 3d 04h 58m
I use the following to convert it to hours:
=LEFT(E2,FIND("d",E2)-1)*24+MID(E2,FIND("h",E2)-2,2)+MID(E2,FIND("m",E2)-2,2)/60
It work fine until I get a unit without the day. 04h 58m. Can I use a if
statement to add all numbers even if the day value is missing?