Prev: calculating clock times
Next: Please help
From: Rehab brain Rehab on 7 Mar 2010 19:57
I am trying get my formula for hours accured in a vacation tracker
spreadsheet to show up as 60 minutes in an hour instead of 100 minutes.

=(D8/(52/$J$12)*D10 results are 1.85 hours, I want it to read 2.25 hours

Cell D8 = 48 hours
Cell $J$12 = 1 weeks per pay period
Cell D10 = 1 accured every # of periods

Same thing is this formula =OFFSET(J18,-1,0,1,1)+D18-G18 where the current
results are 50.81 hours and should show as 51.21 hours.
From: Fred Smith on 7 Mar 2010 23:48
The result *is* 1.85 hours. It's not 1 hour and 85 minutes, as I'm assuming
you're thinking when you want it converted to 2.25 (which would be better
displayed as 2:25).

If you want it displayed as h:mm, then divide by 24, and format as h:mm. But
the result will be 1:51, not 2:25.

Regards,
Fred

"Rehab brain" <Rehab brain(a)discussions.microsoft.com> wrote in message
news:8F03C338-BC74-44BE-A055-059109A7E09A(a)microsoft.com...
>I am trying get my formula for hours accured in a vacation tracker
> spreadsheet to show up as 60 minutes in an hour instead of 100 minutes.
>
> =(D8/(52/$J$12)*D10 results are 1.85 hours, I want it to read 2.25 hours
>
> Cell D8 = 48 hours
> Cell $J$12 = 1 weeks per pay period
> Cell D10 = 1 accured every # of periods
>
> Same thing is this formula =OFFSET(J18,-1,0,1,1)+D18-G18 where the current
> results are 50.81 hours and should show as 51.21 hours.

From: Russell Dawson on 7 Mar 2010 23:51
You need to explain what the contents of the cells are. What does 48
represent in D8? What is "1 weeks per pay period" in J12? What is accrued in
D10?
What are the contents of the cells in row 18?

Please be specific.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Rehab brain" wrote:

> I am trying get my formula for hours accured in a vacation tracker
> spreadsheet to show up as 60 minutes in an hour instead of 100 minutes.
>
> =(D8/(52/$J$12)*D10 results are 1.85 hours, I want it to read 2.25 hours
>
> Cell D8 = 48 hours
> Cell $J$12 = 1 weeks per pay period
> Cell D10 = 1 accured every # of periods
>
> Same thing is this formula =OFFSET(J18,-1,0,1,1)+D18-G18 where the current
> results are 50.81 hours and should show as 51.21 hours.
 | 
Pages: 1
Prev: calculating clock times
Next: Please help