Re: elapsed time

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Peo Sjoblom (terre08_at_mvp.org)
Date: 08/05/04

Next message: Mike_can: "RE: Automatically select combo box possible selections"
Previous message: hlc: "Changing Rows to Columns"
In reply to: ash: "elapsed time"
Messages sorted by: [ date ] [ thread ]

Date: Thu, 5 Aug 2004 10:25:20 -0400

This will round to the nearest minute

=ROUND((B2-A2)/(1/1440),0)*1/1440

if you want to take off all seconds before the subtraction use

=FLOOR(B2,"0:1")-FLOOR(A2,"0:1")

-- 
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"ash" <anonymous@discussions.microsoft.com> wrote in message
news:0a9601c47af6$2e924d60$a401280a@phx.gbl...
> i have 2 different static times and i want to calculate
> the elapsed time between them but i only want to work out
> the hrs and mins not the secs is there a way 2 do this?

Next message: Mike_can: "RE: Automatically select combo box possible selections"
Previous message: hlc: "Changing Rows to Columns"
In reply to: ash: "elapsed time"
Messages sorted by: [ date ] [ thread ]