| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtract minutes from time | Excel Discussion (Misc queries) | |||
| how to subtract time cards in minutes in excel | Excel Worksheet Functions | |||
| How do you subtract time? (ie 03:15 am minus 5 minutes) | Excel Discussion (Misc queries) | |||
| Subtract one time from another and get answer in minutes | Excel Discussion (Misc queries) | |||
| What formula is used to add or subtract minutes from a time in a . | Excel Worksheet Functions | |||
Linear Mode
