Hours to Minutes Formula
Try this:
=MOD(B1-A1,1)*1440
Format as General or Number
--
Biff
Microsoft Excel MVP
"Ana24" wrote in message
...
Is there a formula to calculate minutes? For example: Colum A: 7:00 Colum
B:
8:30... I want Column C to say 90 for minutes instead of 1:30 for
1hr30min,
which is what I currently have. Thanks!
|