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

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

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

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

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

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

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

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

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

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