Elasped Time

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
I have a formula that calculates how much time has passed.

a1 = 1:00 pm
a2 = 1:37 pm
a3 = 0:37

What I want in a4, is a formula that divides a3 by 20 and rounds up.

for example

a4 = 2

Thank you for helping me.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Thanks it worked. I just had to change the cell format to get it to work. Thank you

Yes, it was related to the previous question but I did not know if I worded it properly.
 
Upvote 0
On 2002-03-21 16:19, Parra wrote:
I just had to change the cell format to get it to work

Yeah, I should have mentioned that! If you enter a formula with a reference to a cell that's formatted as a time value Excel applies the same format to the cell containing the formula. Sometimes it can be quite annoying. :eek:
This message was edited by Mark W. on 2002-03-21 16:42
 
Upvote 0

Forum statistics

Threads
1,214,413
Messages
6,119,374
Members
448,888
Latest member
Arle8907

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top