Need to calcualte difference between 2 time fields

  • Thread starter Thread starter Paul D
  • Start date Start date
P

Paul D

Need to calcualte difference between 2 time fields, and
round up to the next minute with a numberic result.


i.e. A1 = Start Time (Format Time) = 8:34:32
B1 = End Time (Format Time) = 8:39:51

I need result of 6
 
=CEILING((B1-A1)*1440,1)

format as general

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
=roundup((B1-A1)*1440,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top