View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default 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!