View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ana24 Ana24 is offline
external usenet poster
 
Posts: 4
Default 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!