Thread: Total Minutes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Total Minutes

Hi

Just subtract one from the other ( =B1-A1 ) and format the result as [mm]

Hope this helps.
Andy.

"Nick I" wrote in message
...
Hi, I have two Date/Time fields in this format:

Field A
5/18/06 10:58 AM

Field B
5/24/06 1:10 PM

What I want to do, is have a field that takes the difference between Field
B
- Field A, and returns the TOTAL MINUTES. Is this possible? I am not very
good with Excel.

Thanks!

Nick