View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j lunis j lunis is offline
external usenet poster
 
Posts: 1
Default easy formula question

How do I perform math calculations on time increments?

For example, 7 * 20 minutes = 2 hours, 20 minutes (2:20),
and 3 hours - 1 hour ten minutes = 1 hour, 50 minutes (1:50).

I know how to format cells to show time but I can't find how to
calculate an answer that shows up as time.