|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 25th, 2008, 09:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
August 25th, 2008, 09:42 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 30 minutes from Formula
Try something like this:
=TEXT(C205-B205-TIME(,30,),"[h] \h\r\s: m \m\i\n\s") Is that something you can work with? *********** Regards, Ron XL2003, WinXP "Karen" wrote: 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
|
|
#3
August 25th, 2008, 09:42 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 30 minutes from Formula
Try this:
=TEXT(C205-B205-TIME(0,30,0),"[h] \h\r\s: m \m\i\n\s") -- Biff Microsoft Excel MVP "Karen" wrote in message ... 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
|
|
#4
August 25th, 2008, 09:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 30 minutes from Formula
Assuming C205 and B205 are valid times....
change your formula to this: ....C205-B205-30/60/24,... Hope this helps. -- John C "Karen" wrote: 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
|
|
#5
August 25th, 2008, 10:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 30 minutes from Formula
Thank you for your help
Karen "Ron Coderre" wrote: Try something like this: =TEXT(C205-B205-TIME(,30,),"[h] \h\r\s: m \m\i\n\s") Is that something you can work with? *********** Regards, Ron XL2003, WinXP "Karen" wrote: 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
|
|
#6
August 25th, 2008, 10:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 30 minutes from Formula
Thank you for your help
Karen "John C" wrote: Assuming C205 and B205 are valid times.... change your formula to this: ...C205-B205-30/60/24,... Hope this helps. -- John C "Karen" wrote: 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
|
|
#7
August 25th, 2008, 10:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 30 minutes from Formula
Thank you for your help
Karen "T. Valko" wrote: Try this: =TEXT(C205-B205-TIME(0,30,0),"[h] \h\r\s: m \m\i\n\s") -- Biff Microsoft Excel MVP "Karen" wrote in message ... 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
|
|
#8
August 25th, 2008, 10:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 30 minutes from Formula
What formula do I use if I want to convert 8 hrs: 45 mins to 8.75?
Thanks again, Karen "Ron Coderre" wrote: Try something like this: =TEXT(C205-B205-TIME(,30,),"[h] \h\r\s: m \m\i\n\s") Is that something you can work with? *********** Regards, Ron XL2003, WinXP "Karen" wrote: 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
|
|
#9
August 25th, 2008, 10:24 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 30 minutes from Formula
Assuming your hours and minutes are in the standard hh:mm format (that is,
8:45 is in the cell), then use... =24*A1 and format the cell A1 as General. Rick "Karen" wrote in message ... What formula do I use if I want to convert 8 hrs: 45 mins to 8.75? Thanks again, Karen "Ron Coderre" wrote: Try something like this: =TEXT(C205-B205-TIME(,30,),"[h] \h\r\s: m \m\i\n\s") Is that something you can work with? *********** Regards, Ron XL2003, WinXP "Karen" wrote: 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
|
|
#10
August 25th, 2008, 11:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 30 minutes from Formula
You're welcome!
-- Biff Microsoft Excel MVP "Karen" wrote in message ... Thank you for your help Karen "T. Valko" wrote: Try this: =TEXT(C205-B205-TIME(0,30,0),"[h] \h\r\s: m \m\i\n\s") -- Biff Microsoft Excel MVP "Karen" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
