Thread
:
Subtract 30 minutes from Formula
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Karen
external usenet poster
Posts: 447
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
Reply With Quote
Karen
View Public Profile
Find all posts by Karen