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

Could try something like this

=Round((B1-A1)*24*60,0)

"Nick I" wrote:

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