Hello:

Using Excel 2002(xp)...

I need to find out the total hours based on a 40hr week. The daily figures
that I will be entering into the cells are in HR:MIN format (it's in this
format to begin with). How can I total this daily time, to display it in
HR:MIN? The total would look like 40:10, which is 40hr and 10min...


Also:
Is there away to convert 40.05hrs to HR:MIN? I like the answer to display
40:03, which is 40hrs and 3 minutes. (40.05 = 40:03) And (vice-versa,
40:03 = 40.05)

Thanks,

Mark

One way:

Use SUM(A1:A10), for example, but format your cell with

Format/Cells/Number/Custom [hh]:mm:ss

where the [] prevents XL's display engine from rolling over times after
24 hours.

XL stores times as fractional days, so to convert 40.05 to 40:05, divide
by 24 hours:

=40.05/24

format the cell as time as above.



In article <(E-Mail Removed)>,
"MarkC" <(E-Mail Removed)> wrote:

> Hello:
>
> Using Excel 2002(xp)...
>
> I need to find out the total hours based on a 40hr week. The daily figures
> that I will be entering into the cells are in HR:MIN format (it's in this
> format to begin with). How can I total this daily time, to display it in
> HR:MIN? The total would look like 40:10, which is 40hr and 10min...
>
>
> Also:
> Is there away to convert 40.05hrs to HR:MIN? I like the answer to display
> 40:03, which is 40hrs and 3 minutes. (40.05 = 40:03) And (vice-versa,
> 40:03 = 40.05)
>
> Thanks,
>
> Mark

Thanks JE:

I now understand the [hh] format, and this is what I was looking for. What
is the deference between using [h] and [hh]?

Thanks again...
Mark


"JE McGimpsey" <(E-Mail Removed)> wrote in message
news:jemcgimpsey-(E-Mail Removed)...
> One way:
>
> Use SUM(A1:A10), for example, but format your cell with
>
> Format/Cells/Number/Custom [hh]:mm:ss
>
> where the [] prevents XL's display engine from rolling over times after
> 24 hours.
>
> XL stores times as fractional days, so to convert 40.05 to 40:05, divide
> by 24 hours:
>
> =40.05/24
>
> format the cell as time as above.
>
>
>
> In article <(E-Mail Removed)>,
> "MarkC" <(E-Mail Removed)> wrote:
>
>> Hello:
>>
>> Using Excel 2002(xp)...
>>
>> I need to find out the total hours based on a 40hr week. The daily
>> figures
>> that I will be entering into the cells are in HR:MIN format (it's in this
>> format to begin with). How can I total this daily time, to display it in
>> HR:MIN? The total would look like 40:10, which is 40hr and 10min...
>>
>>
>> Also:
>> Is there away to convert 40.05hrs to HR:MIN? I like the answer to
>> display
>> 40:03, which is 40hrs and 3 minutes. (40.05 = 40:03) And (vice-versa,
>> 40:03 = 40.05)
>>
>> Thanks,
>>
>> Mark

Try them both on a time < 10:00

In article <(E-Mail Removed)>,
"MarkC" <(E-Mail Removed)> wrote:

> I now understand the [hh] format, and this is what I was looking for. What
> is the deference between using [h] and [hh]?

Unless I'm doing something wrong, there's no difference, or should there be?
Mark

"JE McGimpsey" <(E-Mail Removed)> wrote in message
news:jemcgimpsey-(E-Mail Removed)...
> Try them both on a time < 10:00
>
> In article <(E-Mail Removed)>,
> "MarkC" <(E-Mail Removed)> wrote:
>
>> I now understand the [hh] format, and this is what I was looking for.
>> What
>> is the deference between using [h] and [hh]?

Using 10:00 then there won't be but try 9:00 with both formats.

Having said that the number of times a time in a cell formattted as [h]:mm
is less then 10 hours will probably be few and far between.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
(E-Mail Removed) with @tiscali.co.uk


"MarkC" <(E-Mail Removed)> wrote in message
news:eiRS$(E-Mail Removed)...
> Unless I'm doing something wrong, there's no difference, or should there
> be?
> Mark
>
> "JE McGimpsey" <(E-Mail Removed)> wrote in message
> news:jemcgimpsey-(E-Mail Removed)...
>> Try them both on a time < 10:00
>>
>> In article <(E-Mail Removed)>,
>> "MarkC" <(E-Mail Removed)> wrote:
>>
>>> I now understand the [hh] format, and this is what I was looking for.
>>> What
>>> is the deference between using [h] and [hh]?
>
>

In one case you will get 09:00, and in the other you will get 9:00 -
do you want the leading zero to show or not?

Pete

On Mar 27, 5:38 am, "MarkC" <N...@nospam.com> wrote:
> Unless I'm doing something wrong, there's no difference, or should there be?
> Mark
>
> "JE McGimpsey" <jemcgimp...@mvps.org> wrote in message
>
> news:jemcgimpsey-(E-Mail Removed)...
>
>
>
> > Try them both on a time < 10:00
>
> > In article <OjmVSmybHHA.1...@TK2MSFTNGP03.phx.gbl>,
> > "MarkC" <N...@nospam.com> wrote:
>
> >> I now understand the [hh] format, and this is what I was looking for.
> >> What
> >> is the deference between using [h] and [hh]?- Hide quoted text -
>
> - Show quoted text -

Pete_UK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...> In one case
you will get 09:00, and in the other you will get 9:00

Telltale! <g>

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
(E-Mail Removed) with @tiscali.co.uk


"Pete_UK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> In one case you will get 09:00, and in the other you will get 9:00 -
> do you want the leading zero to show or not?
>
> Pete
>
> On Mar 27, 5:38 am, "MarkC" <N...@nospam.com> wrote:
>> Unless I'm doing something wrong, there's no difference, or should there
>> be?
>> Mark
>>
>> "JE McGimpsey" <jemcgimp...@mvps.org> wrote in message
>>
>> news:jemcgimpsey-(E-Mail Removed)...
>>
>>
>>
>> > Try them both on a time < 10:00
>>
>> > In article <OjmVSmybHHA.1...@TK2MSFTNGP03.phx.gbl>,
>> > "MarkC" <N...@nospam.com> wrote:
>>
>> >> I now understand the [hh] format, and this is what I was looking for.
>> >> What
>> >> is the deference between using [h] and [hh]?- Hide quoted text -
>>
>> - Show quoted text -
>
>

Sandy,

when I responded to this thread (at about 9:20 am) your response was
not visible, yet when I sent it a few minutes later I could then see
what you had put - I wouldn't have bothered if I had read your posting
first (JE had said to try it with <10:00, but I figured that the OP
had misread this). Sometimes responses seem to take a very long time
to get displayed - maybe the electrons have further to travel from
Scotland !! <bg>

Pete

On Mar 27, 1:58 pm, "Sandy Mann" <sandyma...@mailinator.com> wrote:
> Pete_UK" <pashu...@auditel.net> wrote in message
>
> news:(E-Mail Removed)...> In one case
> you will get 09:00, and in the other you will get 9:00
>
> Telltale! <g>
>
> --
> HTH
>
> Sandy
> In Perth, the ancient capital of Scotland
> and the crowning place of kings
>
> sandyma...@mailinator.com
> Repl...@mailinator.com with @tiscali.co.uk
>
> "Pete_UK" <pashu...@auditel.net> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > In one case you will get 09:00, and in the other you will get 9:00 -
> > do you want the leading zero to show or not?
>
> > Pete
>
> > On Mar 27, 5:38 am, "MarkC" <N...@nospam.com> wrote:
> >> Unless I'm doing something wrong, there's no difference, or should there
> >> be?
> >> Mark
>
> >> "JE McGimpsey" <jemcgimp...@mvps.org> wrote in message
>
> >>news:jemcgimpsey-(E-Mail Removed)...
>
> >> > Try them both on a time < 10:00
>
> >> > In article <OjmVSmybHHA.1...@TK2MSFTNGP03.phx.gbl>,
> >> > "MarkC" <N...@nospam.com> wrote:
>
> >> >> I now understand the [hh] format, and this is what I was looking for.
> >> >> What
> >> >> is the deference between using [h] and [hh]?- Hide quoted text -
>
> >> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -