Hours to Minutes Formula
 

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!

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!

Hours to Minutes Formula
 

Hi,

Try this

=(B3-A3)*60*24

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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!

Hours to Minutes Formula
 

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

"Ashish Mathur" wrote:

Hi,

Try this

=(B3-A3)*60*24

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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!

Hours to Minutes Formula
 

You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Ana24" wrote in message
...
This worked perfectly. Thank You!!!!!!

"Ashish Mathur" wrote:

Hi,

Try this

=(B3-A3)*60*24

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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!