View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Karen is offline
external usenet poster
 
Posts: 447
Default Subtract 30 minutes from Formula

I have a cell that calculates my time with the following formula:
=TEXT(C205-B205,"[h] \h\r\s: m \m\i\n\s")

I want to subtract 30 minutes for lunch. How would I adjust the formula to
calculate that?

Thanks, Karen