# Thread: Deducting time from time (2003)

1. ## Deducting time from time (2003)

Almost 5pm Friday afternoon and I have a huge block.
I have to deduct time from time.
I refer to say, cell B4. B4 contains 13:30 (24 hour clock)
In the other cell I want to say =B4 minus 30 minutes...

How do I do that again ???

Thanks

2. ## Re: Deducting time from time (2003)

Welcome to the lounge.

The following formula will work, recognizing that Excel assigns a value of 1 to a 24 hour day,

=B4-30/24/60

3. ## Re: Deducting time from time (2003)

Thanks and have a great weekend

4. ## Re: Deducting time from time (2003)

The formula that Don gave you will certainly work. I would like to add an additional way that might be a little easier to understand when you look at the formula again a year from now. The TIME() function can be used to convert a time into Excel's internal representation of time as fractions of a day. Therefore, you could also use the following formula:

<code>
=B4-TIME(0,30,0)
</code>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•