Time Sheet Calculation problem

I've never worked with TIME before in Quattro and am not getting results I 
want.

I'm setting up a time sheet. It has Morning In and Out and Afternoon In and 
out.

If I work from 7:45am to 11:50 am    and then 1;15 to 4:00   What formula do 
I use and how do I calculate the amount of time actually worked?
Sometimes we work thru lunch so from 7:45 to 4:00.
(Side problem / Quesiton... I was entering the hours in 24 hr format but 
when leaving the field it would change it. Ex I would enter 17:00 and when 
leaving it would change it to 5:00.)

Do I have to change format of the cell? The answers that I am getting are 
way off!

Thanks

 

I have continued to play and seem to have most of it worked out now.

I can get the am and pm formulas to work for each day and give me the total 
hours and min worked for the day (Col F).

Now my problem is  that i have calculated the total hours for the day in col 
F.
(F1) day 1, 3 hours
(F2) Day 2 6 hours
(F3) day 3 7 hours

I can not get it to add the total hours worked forthe week in (Col G). 
(Should be 16) I've tried formatting for Date and number but neither give me 
the correct total.
Any suggestions?
thanks





"Brad Morris" <bradmorris@mchsi.com> wrote in message 
news:47d8b7a6$1_1@cnews...
>
> I've never worked with TIME before in Quattro and am not getting results I

> want.
>
> I'm setting up a time sheet. It has Morning In and Out and Afternoon In 
> and out.
>
> If I work from 7:45am to 11:50 am    and then 1;15 to 4:00   What formula 
> do I use and how do I calculate the amount of time actually worked?
> Sometimes we work thru lunch so from 7:45 to 4:00.
> (Side problem / Quesiton... I was entering the hours in 24 hr format but 
> when leaving the field it would change it. Ex I would enter 17:00 and when

> leaving it would change it to 5:00.)
>
> Do I have to change format of the cell? The answers that I am getting are 
> way off!
>
> Thanks
>
>
>
>
> 

Brad Morris wrote:
> I have continued to play and seem to have most of it worked out now.
> 
> I can get the am and pm formulas to work for each day and give me the total

> hours and min worked for the day (Col F).
> 
> Now my problem is  that i have calculated the total hours for the day in
col 
> F.
> (F1) day 1, 3 hours
> (F2) Day 2 6 hours
> (F3) day 3 7 hours
> 
> I can not get it to add the total hours worked forthe week in (Col G). 
> (Should be 16) I've tried formatting for Date and number but neither give
me 
> the correct total.

It's important to distinguish between time DISPLAY and time VALUE.  The time of

day is treated in QP as a fraction of 1, where the value 1 represents 24 hours 
(1 day).  E.g., if you enter 17:00, the underlying time value (shown in the 
input line) is 0.708333333333333.

When calculating time, remember that the simple result is expressed in terms of

days, or fractions of days.  Your "hours" in column F are probably NOT
hours at 
all, but fractions of days FORMATTED to be DISPLAYED in terms of hours and 
minutes.  The display format is only for looks.  To convert the actual VALUE of

the time difference to hours, you need to use a formula like 
+(StartTime-EndTime)*24.


> "Brad Morris" <bradmorris@mchsi.com> wrote in message 
> news:47d8b7a6$1_1@cnews...
>> I've never worked with TIME before in Quattro and am not getting
results I 
>> want.
>>
>> I'm setting up a time sheet. It has Morning In and Out and Afternoon In

>> and out.
>>
>> If I work from 7:45am to 11:50 am    and then 1;15 to 4:00   What
formula 
>> do I use and how do I calculate the amount of time actually worked?
>> Sometimes we work thru lunch so from 7:45 to 4:00.
>> (Side problem / Quesiton... I was entering the hours in 24 hr format
but 
>> when leaving the field it would change it. Ex I would enter 17:00 and
when 
>> leaving it would change it to 5:00.)
>>
>> Do I have to change format of the cell? The answers that I am getting
are 
>> way off!

Your display being changed to 5:00 is a bit strange; depending on how your 
system is configured, it should display either 17:00 or 5:00 AM.  The display, 
however, can always be customized to one of the time formats under Numeric 
formats, which includes a 24-hour clock display.  There are two different ways 
to customize your display of time in QP:  either set the default display under 
QP International Time setting, or format the display for the specific cell 
containing the time value.

Cheers,
Uli

Brad:
> I've never worked with TIME before in Quattro and am not getting results I

> want.
> 
> I'm setting up a time sheet. It has Morning In and Out and Afternoon In and

> out.

You may wish to check the article Elapsed Time in
corel.quattropro-faq
where you will find a full exposition on the topic.

I usually go for a DIY solution - I use one Col for Hrs, another for Mins, and 
knock up suitable formulae to produce the result.

> (Side problem / Quesiton... I was entering the hours in 24 hr format but 
> when leaving the field it would change it. Ex I would enter 17:00 and when

> leaving it would change it to 5:00.)

You choose the display in the usual way:
Format|Selection|Numeric Format|Time...
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

Brad:
> my problem is  that i have calculated the total hours for the day in col 
> F.
> (F1) day 1, 3 hours
> (F2) Day 2 6 hours
> (F3) day 3 7 hours

It is not clear in what format the Hours totals are held: still in QP Time 
format? or as straight numbers.

> I can not get it to add the total hours worked for the week in (Col G). 
> (Should be 16) I've tried formatting for Date and number but neither give
me 
> the correct total.

If you add QP's Hr:Min values you get an Hr:Min result. The display is designed

to show actual time, not elapsed time, which I suppose is what you need.
You can use @HOUR() and @MINUTE().
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)