| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Minutes elapset between two cells
Lookikng for an easy way to calculate the minutes elapsed between two cells.
The minutes will elapse over different days. A1 = 7/7/2009 7:00:00 AM A2 = 8/8/2009 7:00:00 AM A3 = (the function I need) (should be 1440) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Minutes elapset between two cells
I think your example is wrong, as there are way more than 1440 minutes in a 1
month span. Assuming you meant 7/8/2009 as second date: =(A2-A1)*1440 1440 minutes/day = 24 hrs/day * 60 minutes/hr -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "bazsil,73" wrote: Lookikng for an easy way to calculate the minutes elapsed between two cells. The minutes will elapse over different days. A1 = 7/7/2009 7:00:00 AM A2 = 8/8/2009 7:00:00 AM A3 = (the function I need) (should be 1440) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Minutes elapset between two cells
=(A2-A1)*24*60 but the answer is 46080, not 1440. The dates are 32 days
apart, not 1 day. -- David Biddulph "bazsil,73" wrote in message ... Lookikng for an easy way to calculate the minutes elapsed between two cells. The minutes will elapse over different days. A1 = 7/7/2009 7:00:00 AM A2 = 8/8/2009 7:00:00 AM A3 = (the function I need) (should be 1440) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Minutes elapset between two cells
You are correct in my mistake with the example....thanks.
=(A2-A1)*24*60 but the answer is 46080, not 1440. The dates are 32 days apart, not 1 day. -- David Biddulph "bazsil,73" wrote in message ... Lookikng for an easy way to calculate the minutes elapsed between two cells. The minutes will elapse over different days. A1 = 7/7/2009 7:00:00 AM A2 = 8/8/2009 7:00:00 AM A3 = (the function I need) (should be 1440) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Minutes elapset between two cells
I was having trouble getting the functions reslult to display properly but
when I formulated it as a "general" type cell it works perfect. Thanks again. "David Biddulph" wrote: =(A2-A1)*24*60 but the answer is 46080, not 1440. The dates are 32 days apart, not 1 day. -- David Biddulph "bazsil,73" wrote in message ... Lookikng for an easy way to calculate the minutes elapsed between two cells. The minutes will elapse over different days. A1 = 7/7/2009 7:00:00 AM A2 = 8/8/2009 7:00:00 AM A3 = (the function I need) (should be 1440) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i Calculate minutes between two different dates | Excel Discussion (Misc queries) | |||
| Format Cells to calculate hours and minutes taken to complete task | Excel Worksheet Functions | |||
| Calculate minutes from timecard | Excel Worksheet Functions | |||
| how do I calculate minutes when given two times? | Excel Worksheet Functions | |||
| how do i calculate minutes between two times? | Excel Discussion (Misc queries) | |||
Linear Mode
