Time Calculation

[Daywalker]

Hi,

I am trying to get a sum value of time, trying to get it to input the time only and calculate the total number of hours and minutes worked.

ie:

Start Time 11.05 (24 hour clock)
Lunch 0.30 (minutes)
Finsh Time 19.00 (24 hour clock)

Total Minutes 0.445
Total Hours 7.10

Have tried many ways of doing this, but cannot get it to work.

Can anyone help ?

Cheers,

Daywalker

[Marcus Fox]

"Daywalker" <Daywalker.25i1b2_1143749828.3941@excelforum-nospam.com> wrote
in message news:Daywalker.25i1b2_1143749828.3941@excelforum-nospam.com...
>
> Hi,
>
> I am trying to get a sum value of time, trying to get it to input the
> time only and calculate the total number of hours and minutes worked.
>
> ie:
>
> Start Time 11.05 (24 hour clock)
> Lunch 0.30 (minutes)
> Finsh Time 19.00 (24 hour clock)
>
> Total Minutes 0.445
> Total Hours 7.10
>
> Have tried many ways of doing this, but cannot get it to work.
>
> Can anyone help ?
>
> Cheers,
>
> Daywalker

Enter the start time and the finish time of each. Example - 11:05 and 15:00,
then 15:30 and 19:00. Subtract the start time from the finish time and add
the two together. Choose the format for the number of hours worked as
[hh]:mm:ss

Marcus

[Pete_UK]

You have a full stop between the hours and minutes in your examples -
are the cells formatted this way (i.e. are they true Excel times), or
are these just numeric values representing time?

This is crucial to any formulae which might be developed to help you -
please post back.

Pete

[Daywalker]

Cells are set as numeric value, not time

[Marcus Fox]

"Daywalker" <Daywalker.25i2oz_1143751510.0244@excelforum-nospam.com> wrote
in message news:Daywalker.25i2oz_1143751510.0244@excelforum-nospam.com...
>
> Cells are set as numeric value, not time

Thats your problem. You need to format cells as time with a colon in
between, or else use decimal time, for example, every fifteen minutes add
0.25.

Marcus

[Pete_UK]

I agree with Marcus - the formulae needed to handle decimal times will
be much more complicated.

Is this acceptable to you? Do you need any more advice/help?

Pete