Thread: How do I add up time and minutes in a spreadsheet?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Todd B. Todd B. is offline
external usenet poster
  
Posts: 1
Default How do I add up time and minutes in a spreadsheet?
I need to add the total time and minutes (hours worked) in a colum, but when
I use the =SUM(a1,a2) function it adds the numbers in hundredths and not time
format.

Example: Monday 7:55 NOT: Monday 7:55
Tuesday 8:10 Tuesday 8:10
= 16:05 = 15:65

I cant find anything in the help that addresses this.

Thanks


Reply With QuoteReply With Quote