 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
05-21-2008, 02:03 PM
|
|||
|
|||
|
Simple Date problem -_- Please Help !
Hi everyone,
I have list of times in hh:mm format from cell A1 to A730 e.g. 9:30, 13:00, 13:32, 12:12 etc... How do I put number of minutes passed from 9:00AM i.e. if A1 has 9:30 then B1 must display 30, if A2 has 14:12 then B2 displays 312 and so on. What kind of function do I need to use? Please help! Thanks alot :D 
|
|
05-21-2008, 02:32 PM
|
|||
|
|||
|
Re: Simple Date problem -_- Please Help !
format cell as [mm] and use
=A1-TIME(9,0,0) James8309 wrote: > Hi everyone, > > I have list of times in hh:mm format from cell A1 to A730 > > e.g. 9:30, 13:00, 13:32, 12:12 etc... > > How do I put number of minutes passed from 9:00AM > > i.e. if A1 has 9:30 then B1 must display 30, if A2 has 14:12 then B2 > displays 312 and so on. > > What kind of function do I need to use? > > > Please help! Thanks alot :D > >
|
|
05-21-2008, 02:33 PM
|
|||
|
|||
|
Re: Simple Date problem -_- Please Help !
Put this in B1:
=A1 - 9/24 and apply a custom format of [mm] Then copy it down your 730 rows. Hope this helps. Pete On May 21, 2:03*pm, James8309 <jaedong1...@gmail.com> wrote: > Hi everyone, > > I have list of times in hh:mm format from cell A1 to A730 > > e.g. 9:30, 13:00, 13:32, 12:12 etc... > > How do I put number of minutes passed from 9:00AM > > i.e. if A1 has 9:30 then B1 must display 30, if A2 has 14:12 then B2 > displays 312 and so on. > > What kind of function do I need to use? > > Please help! Thanks alot :D
|
|
05-21-2008, 03:58 PM
|
|||
|
|||
|
Re: Simple Date problem -_- Please Help !
Bonsour® James8309 avec ferveur ;o))) vous nous disiez :
> Hi everyone, > > I have list of times in hh:mm format from cell A1 to A730 > > e.g. 9:30, 13:00, 13:32, 12:12 etc... > > How do I put number of minutes passed from 9:00AM > > i.e. if A1 has 9:30 then B1 must display 30, if A2 has 14:12 then B2 > displays 312 and so on. > > What kind of function do I need to use? =(A1-"9:00 AM")/"0:1" number format -- -- @+ ;o)))
|
|
05-21-2008, 11:50 PM
|
|||
|
|||
|
Re: Simple Date problem -_- Please Help !
On May 22, 12:58*am, "Mais qui est Paul" <Excel-add...@mpfe.fr> wrote:
> Bonsour® James8309 *avec ferveur *;o))) vous nous disiez : > > > Hi everyone, > > > I have list of times in hh:mm format from cell A1 to A730 > > > e.g. 9:30, 13:00, 13:32, 12:12 etc... > > > How do I put number of minutes passed from 9:00AM > > > i.e. if A1 has 9:30 then B1 must display 30, if A2 has 14:12 then B2 > > displays 312 and so on. > > > What kind of function do I need to use? > > =(A1-"9:00 AM")/"0:1" > number format > > -- > -- > @+ > ;o))) Thanks everyone!!! :D
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
