View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
N Harkawat N Harkawat is offline
external usenet poster
 
Posts: 55
Default Calculating the number of minutes between days


=(SUBSTITUTE(A1,".","")-SUBSTITUTE(A2,".",""))*1440

assuming A1 and A2 contain the 2 dates

If the dates have no decimal points around am and pm you could simply
subtract one from another and multiply the result by 1440

"Jennifer Duffer" wrote:

I need to calculate the number of minutes between two times on two different
days.

For example:

2/6/2008 12:35 p.m.
2/8/2008 4:17 a.m.

Any thoughts or direction I should go?

Thanks much in advance!