Prev: Merging cells
Next: SOLVED: Input calculation in specified rows and columns
From: John on 19 Feb 2010 13:26
I should have said that you can format as time only and it will show just the
time.
HTH
John
"John" <johnd(a)newlook.com> wrote in message
news:%230bHyAZsKHA.1796(a)TK2MSFTNGP02.phx.gbl...
> Hi Blueriver
>
> The problem is that XL does not know that 12 AM is the next day if you put the
> date & time in the cell, your formula should work . "Formating as General "
> e.g. Time IN 2/19/2010 22:00
> Time OUT 2/20/2010 00:00
> HTH
> John
>
>
> "blueriver" <blueriver(a)discussions.microsoft.com> wrote in message
> news:C384E142-799C-4399-BEF4-B7171F47F278(a)microsoft.com...
>>I am sure this question has been answered before but I am dizzy trying to
>> sort through all of the other posts when I run a search.
>>
>> I have a spreadsheet that does some pretty basic time in and time outs. I
>> have a validation table only allowing time on the quarter of an hour for the
>> time in and time out. It is formatted in 12:00 AM time.
>>
>> In this particular instance I cannot get my formula to work when the end
>> time is 12:00 AM. E.g.:
>>
>> Start time (D9) is 10:00 PM, End time (E9) is 12:00 AM. My formula reads
>> =IF(E9>0,(E9-D9)*1440/60,""). This formula returns nothing when the end time
>> is 12:00 AM. I need it to return 2.00 for the amount of hours.
>>
>> Any thoughts and Thanks!
>> -CRM
>>
>

From: blueriver on 19 Feb 2010 14:15
THANK YOU ALL!!!!

"Teethless mama" wrote:

> =MOD(E9-D9,1)*24
>
> Format cell as General
>
> "blueriver" wrote:
>
> > I am sure this question has been answered before but I am dizzy trying to
> > sort through all of the other posts when I run a search.
> >
> > I have a spreadsheet that does some pretty basic time in and time outs. I
> > have a validation table only allowing time on the quarter of an hour for the
> > time in and time out. It is formatted in 12:00 AM time.
> >
> > In this particular instance I cannot get my formula to work when the end
> > time is 12:00 AM. E.g.:
> >
> > Start time (D9) is 10:00 PM, End time (E9) is 12:00 AM. My formula reads
> > =IF(E9>0,(E9-D9)*1440/60,""). This formula returns nothing when the end time
> > is 12:00 AM. I need it to return 2.00 for the amount of hours.
> >
> > Any thoughts and Thanks!
> > -CRM
> >
From: Teethless mama on 19 Feb 2010 15:22
You're Welcome!

"blueriver" wrote:

> THANK YOU ALL!!!!
>
> "Teethless mama" wrote:
>
> > =MOD(E9-D9,1)*24
> >
> > Format cell as General
> >
> > "blueriver" wrote:
> >
> > > I am sure this question has been answered before but I am dizzy trying to
> > > sort through all of the other posts when I run a search.
> > >
> > > I have a spreadsheet that does some pretty basic time in and time outs. I
> > > have a validation table only allowing time on the quarter of an hour for the
> > > time in and time out. It is formatted in 12:00 AM time.
> > >
> > > In this particular instance I cannot get my formula to work when the end
> > > time is 12:00 AM. E.g.:
> > >
> > > Start time (D9) is 10:00 PM, End time (E9) is 12:00 AM. My formula reads
> > > =IF(E9>0,(E9-D9)*1440/60,""). This formula returns nothing when the end time
> > > is 12:00 AM. I need it to return 2.00 for the amount of hours.
> > >
> > > Any thoughts and Thanks!
> > > -CRM
> > >
From: WallyWallWhackr on 21 Feb 2010 12:49



On Fri, 19 Feb 2010 09:53:04 -0800, blueriver
<blueriver(a)discussions.microsoft.com> wrote:

>I am sure this question has been answered before but I am dizzy trying to
>sort through all of the other posts when I run a search.
>
>I have a spreadsheet that does some pretty basic time in and time outs. I
>have a validation table only allowing time on the quarter of an hour for the
>time in and time out. It is formatted in 12:00 AM time.
>
>In this particular instance I cannot get my formula to work when the end
>time is 12:00 AM. E.g.:
>
>Start time (D9) is 10:00 PM, End time (E9) is 12:00 AM. My formula reads
>=IF(E9>0,(E9-D9)*1440/60,""). This formula returns nothing when the end time
>is 12:00 AM. I need it to return 2.00 for the amount of hours.
>
>Any thoughts and Thanks!
>-CRM


http://office.microsoft.com/en-us/templates/TC300083091033.aspx

or if that link fails find the task tracking log on this page. It allows
for time increment selection, and it tallies the data separate from the
main data entry sheet/print job sheet/page.

http://office.microsoft.com/en-us/templates/profile.aspx?id=ecf5ad5a-9584-4787-bb16-70f61ad52e0f
First  |  Prev  | 
Pages: 1 2
Prev: Merging cells
Next: SOLVED: Input calculation in specified rows and columns