Thread: How to sum and substract hours, minutes and seconds
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rana Rana is offline
external usenet poster
  
Posts: 9
Default How to sum and substract hours, minutes and seconds
Hello,
I'm searching for a function that count hours, minutes and seconds. When I
use SUM to count 18:45 and 16.30 it keep giving me 11:15 as a result,
although when I highlight 18:45 and 16.30 it shows that the sum is 35:15 in
the bar bellow. Any suggestions?
Reply With QuoteReply With Quote