Calculating 40hr work week

[MarkC]

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

 

[JE McGimpsey]

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.

 

[MarkC]

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

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.

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

 

[JE McGimpsey]

Try them both on a time < 10:00

 

[MarkC]

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

Try them both on a time < 10:00

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

 

[Sandy Mann]

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 address removed)
(e-mail address removed) with @tiscali.co.uk

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

Try them both on a time < 10:00

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

 

[Pete_UK]

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

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

Try them both on a time < 10:00

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 Mann]

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 address removed)
(e-mail address removed) with @tiscali.co.uk

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

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

Try them both on a time < 10:00

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]

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

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 address removed)
(e-mail address removed) with @tiscali.co.uk

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

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

Try them both on a time < 10:00

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 -