| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT formula using hours:minutes | Excel Discussion (Misc queries) | |||
| Hours and minutes display as date in formula box | Excel Discussion (Misc queries) | |||
| HOW TO I CALCULATE HOURS AND MINUTES? NEED FORMULA | Excel Worksheet Functions | |||
| add hours & minutes to other hours & minutes to receive total hou. | Excel Worksheet Functions | |||
| Formula for minutes to days:hours:minutes | Excel Discussion (Misc queries) | |||
Linear Mode
