convert d hh:mm into mm in excel!!!

**BineUSA** · 07-01-2009, 10:27 PM

I 've got data in excel displayed in d hh:mm format and can't work with it.

For calculations I need this enlapsed time in minutes. Had someone work with this, maybe a macro..??? Any help is appriciated! Thanks

Sabine

**xml-looser** · 07-09-2009, 08:54 AM

format cell with int value

then use cell with value*24*60
result are min

**xml-looser** · 07-09-2009, 09:12 AM

format cell with
[m]

**Hack** · 07-09-2009, 11:20 AM

Moved To VB Classic (which also covers VBA)

Thread: convert d hh:mm into mm in excel!!!