answersLogoWhite

0


Best Answer

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:

=C3-B3

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you calculate time from open time to close time in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How many workbooks are open on the taskbar when you first install Excel?

No workbooks are open when you first install excel. The first time you use excel, you will have one workbook open.


A calculation used in excell?

Calculate means Excel will evaluate formulas and functions to display the result. You can turn calculate to manual or auto. When it is on auto, everything is updated in real time. Manual will update when you open Excel or requires to you click the calculate button every time you want to see results.


What time does macy open and close?

What time does Macy s open today and close d


What time does Macy's temecula close today?

What time do macys close


What time the museum its open and time close?

that depends on which museum, unless all museums open and close at the same time right?


What is the name of the Excel feature that recalculates formulas every time you enter a value into a cell?

auto-calculate


What time does the new york stock exchange currently open and close?

= What time does the new york stock exchange currently open and close? =


What time will aeropostale open and close?

There are different times that an aeropostale will open and close in different states and cities. That one is impossible to answer because each aeropostale will open and close at a different time than another.You can also try Google.


What time does macy open today and closed?

What time does Macy s open today and close d


What time does Wells Fargo close?

Not all Wells Fargo's have the same hours. Some branches are open Monday through Friday from 9am to 6pm. Some are even open from 9am to 2pm on Saturdays.


What time do charity shops close?

Charity shops can close at any time but they mostly close at 5:30 and open at 9:30


What time does the statue of liberty open and what time does it close?

it open at 9:00 am and closes at 5:00 pm