Re: Rounding time to the next minute

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 04/07/04 

Date: Wed, 7 Apr 2004 19:27:19 +0200

Hi
try
=ROUNDUP(A1*24*60,0)/(24*60)
and format the resulting cell as time 

--
Regards
Frank Kabel
Frankfurt, Germany
"Paul D" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:19ccb01c41cc4$d2797740$a101280a@phx.gbl...
> Rounding time to the next minute
> I have a time 00:02:12 I need to have as a numberic value
> and rounded up to the netx minute, I need to get a value
> of 3

Relevant Pages

  • Re: Stuck on cut problem
    ... "Paul" schrieb im Newsbeitrag ... > I rewrote the program as follows: ...
    (comp.lang.prolog)
  • Re: need to determine a text value of a field based upon a number
    ... Frank Kabel ... "Paul D" schrieb im Newsbeitrag ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Inactive record
    ... --- "Paul" schrieb im Newsbeitrag ... > Hi just wondering if there is a way to have one record in a table be read> only, were an application can not remove it and have all other records act> normally? ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot Map Network drives
    ... You can see the other clients, but not the shares if you dblClick them? ... "Paul D" schrieb im Newsbeitrag ...
    (microsoft.public.windows.server.sbs)
  • Re: Wireless settings
    ... I just thought Ethman would be a solution, because a note in MSDN says: ... When Ethman adds a wireless adapter, a dialog box that allows the user ... Paul G. Tobey schrieb: ...
    (microsoft.public.windowsce.embedded.vc)