Hi,
I want to write a time in a cell e.g. 12 minutes.
then i want it to automatically divide 12 with 1440, without doing any extra typing.
how do i do this ?
thanks in advance!
Hi,
I want to write a time in a cell e.g. 12 minutes.
then i want it to automatically divide 12 with 1440, without doing any extra typing.
how do i do this ?
thanks in advance!
In an adjacent cell (B1 for example), enter a formula like =A1/1440. From then on, every time you enter a number in A1, B1 will show quotient.
Originally Posted by shg
ye, that i know
but i want it to be in one cell.. eg i enter 12 in A1 and press enter then i calc 12/1440.
You'll need VBA
Like in this link
Last edited by Pepe Le Mokko; 05-06-2013 at 09:26 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks