Thread: Time function needed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Time function needed
These functions should work with time..Apply the formula and format the
formula cell to the required time format and see.

Also readout this must read article by Chip Pearson.
http://www.cpearson.com/excel/datetime.htm

--
Jacob


"wynand" wrote:

Is there any function (or vba) to determine the earliest and latest time
(00:00:00) in a range?Tried max, min, small to no avail.
Reply With QuoteReply With Quote