Subtract 30 minutes from Formula

[Karen]

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

 

[Ron Coderre]

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

 

[T. Valko]

Try this:

=TEXT(C205-B205-TIME(0,30,0),"[h] \h\r\s: m \m\i\n\s")

 

[John C]

Assuming C205 and B205 are valid times....
change your formula to this:
....C205-B205-30/60/24,...

Hope this helps.

 

[Karen]

Thank you for your help
Karen

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

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

 

[Karen]

Thank you for your help
Karen

Assuming C205 and B205 are valid times....
change your formula to this:
...C205-B205-30/60/24,...

Hope this helps.
--
John C

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

 

[Karen]

Thank you for your help
Karen

Try this:

=TEXT(C205-B205-TIME(0,30,0),"[h] \h\r\s: m \m\i\n\s")

--
Biff
Microsoft Excel MVP

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

 

[Karen]

What formula do I use if I want to convert 8 hrs: 45 mins to 8.75?
Thanks again, Karen

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

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

 

[Rick Rothstein \(MVP - VB\)]

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

What formula do I use if I want to convert 8 hrs: 45 mins to 8.75?
Thanks again, Karen

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

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

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you for your help
Karen

Try this:

=TEXT(C205-B205-TIME(0,30,0),"[h] \h\r\s: m \m\i\n\s")

--
Biff
Microsoft Excel MVP

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