How do you calculate time from open time to close time in Excel?
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-B3You 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-B3You 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-B3You 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-B3You 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-B3You 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-B3You 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-B3You 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-B3You 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-B3You 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-B3You 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