Hours to Minutes Formula

[Ana24]

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!

 

[T. Valko]

Try this:

=MOD(B1-A1,1)*1440

Format as General or Number

 

[Ashish Mathur]

Hi,

Try this

=(B3-A3)*60*24

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Ana24]

This worked perfectly. Thank You!!!!!!

Hi,

Try this

=(B3-A3)*60*24

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Ashish Mathur]

You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com