Thread: calculate time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default calculate time

Add.
In case result is more than 24 hours
Format cell as Custom [h]:mm

Steve

On Mon, 16 Oct 2006 12:15:24 +0100, Mr Frank Hellbusch
wrote:

Hi

I need a formula that will total the time using the 24 hour clock, e.g..
06:30 17:00.

Thanks
Frank