Prev: Alternate row comparison
Next: N/A Error with VLOOKUP Formula - Excel 2007
From: JES on 26 Dec 2009 11:47
I have created a table which shows the amount of volunteer hours I have
worked each day. I then created another column which I wish to create a
running total of the hours worked each day. e.g:
A B C
1 Date Hours Running Total
2 01/09/09 03:30 03:30
3 02/09/09 03:30 07:00

However, when I get passed 24 hours, it goes back to 0 because the cells are
in time format. How can I create the running total to count the hours for
each day whilst overriding the 24 hour rule? Thank You in anticipation for
your help.
From: Per Jessen on 26 Dec 2009 12:09
Hi

Format the running total column as Custom : [h]:mm

Regards,
Per

"JES" <JES(a)discussions.microsoft.com> skrev i meddelelsen
news:51109CE4-0627-4BC7-892D-3C1A08F1B79C(a)microsoft.com...
>I have created a table which shows the amount of volunteer hours I have
> worked each day. I then created another column which I wish to create a
> running total of the hours worked each day. e.g:
> A B C
> 1 Date Hours Running Total
> 2 01/09/09 03:30 03:30
> 3 02/09/09 03:30 07:00
>
> However, when I get passed 24 hours, it goes back to 0 because the cells
> are
> in time format. How can I create the running total to count the hours for
> each day whilst overriding the 24 hour rule? Thank You in anticipation for
> your help.

From: T. Valko on 26 Dec 2009 12:14
Format the Running Total formula cells as [h]:mm

The brackets [ ] keep the hours from rolling over after 24.

--
Biff
Microsoft Excel MVP


"JES" <JES(a)discussions.microsoft.com> wrote in message
news:51109CE4-0627-4BC7-892D-3C1A08F1B79C(a)microsoft.com...
>I have created a table which shows the amount of volunteer hours I have
> worked each day. I then created another column which I wish to create a
> running total of the hours worked each day. e.g:
> A B C
> 1 Date Hours Running Total
> 2 01/09/09 03:30 03:30
> 3 02/09/09 03:30 07:00
>
> However, when I get passed 24 hours, it goes back to 0 because the cells
> are
> in time format. How can I create the running total to count the hours for
> each day whilst overriding the 24 hour rule? Thank You in anticipation for
> your help.


 | 
Pages: 1
Prev: Alternate row comparison
Next: N/A Error with VLOOKUP Formula - Excel 2007