Date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Mike,

You can write the corresponding expression in VBA, using Instr() instead
of FIND().
 
Back
Top