It's about time again

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hi,

I am keeping track of time I work at home. The first formula in cells E2 through E17 gives me the total hours I worked after entering starting time and ending time. The second formula calculates the totals from the E column. A problem arises when the sum is more than 24, if it's 27 hours, the answer is 3 instead of 27. What can I use so the sum of my hours just get totaled?

Thanks,
Linda

Starts in cell E2 and goes to E17
=MOD(C2-B2,1)


=SUM(E2:E17)
 
Format the cell with a custom number format of

[h]:mm
or
[h]:mm:ss


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




Hi,

I am keeping track of time I work at home. The first formula in
cells E2 through E17 gives me the total hours I worked after
entering starting time and ending time. The second formula
calculates the totals from the E column. A problem arises when
the sum is more than 24, if it's 27 hours, the answer is 3
instead of 27. What can I use so the sum of my hours just get
totaled?

Thanks,
Linda

Starts in cell E2 and goes to E17
=MOD(C2-B2,1)


=SUM(E2:E17)
 
How or where do I type that? I looked in the cell properties and selected custom and h:mm but it keeps reverting back to the time format.

Thanks,
Linda
Format the cell with a custom number format of

[h]:mm
or
[h]:mm:ss


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




Hi,

I am keeping track of time I work at home. The first formula in
cells E2 through E17 gives me the total hours I worked after
entering starting time and ending time. The second formula
calculates the totals from the E column. A problem arises when
the sum is more than 24, if it's 27 hours, the answer is 3
instead of 27. What can I use so the sum of my hours just get
totaled?

Thanks,
Linda

Starts in cell E2 and goes to E17
=MOD(C2-B2,1)


=SUM(E2:E17)
 
Hey, nevermind. I figured it out. I typed it in the custom box over the other h:mm and it worked.

Linda
How or where do I type that? I looked in the cell properties and selected custom and h:mm but it keeps reverting back to the time format.

Thanks,
Linda
Format the cell with a custom number format of

[h]:mm
or
[h]:mm:ss


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




Hi,

I am keeping track of time I work at home. The first formula in
cells E2 through E17 gives me the total hours I worked after
entering starting time and ending time. The second formula
calculates the totals from the E column. A problem arises when
the sum is more than 24, if it's 27 hours, the answer is 3
instead of 27. What can I use so the sum of my hours just get
totaled?

Thanks,
Linda

Starts in cell E2 and goes to E17
=MOD(C2-B2,1)


=SUM(E2:E17)
 
I changed my mind....I do have one more question.

What is the difference between [h]:mm which after I typed that in my custom box the total hours returned were correct and h:mm which was in the properties of the custom format but not calculating total hours past 24?

Thanks,
Linda
Hey, nevermind. I figured it out. I typed it in the custom box over the other h:mm and it worked.

Linda
How or where do I type that? I looked in the cell properties and selected custom and h:mm but it keeps reverting back to the time format.

Thanks,
Linda
Format the cell with a custom number format of

[h]:mm
or
[h]:mm:ss


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




Hi,

I am keeping track of time I work at home. The first formula in
cells E2 through E17 gives me the total hours I worked after
entering starting time and ending time. The second formula
calculates the totals from the E column. A problem arises when
the sum is more than 24, if it's 27 hours, the answer is 3
instead of 27. What can I use so the sum of my hours just get
totaled?

Thanks,
Linda

Starts in cell E2 and goes to E17
=MOD(C2-B2,1)


=SUM(E2:E17)
 
the brackets tell XL's display engine not to "roll over" the hours every
24, but to show the total hours.

Similarly, [m]:ss will cause XL to display the number of minutes, rather
than rolling over every 60.
 
Gee, I can't believe how time flys. Thanks!
the brackets tell XL's display engine not to "roll over" the hours every
24, but to show the total hours.

Similarly, [m]:ss will cause XL to display the number of minutes, rather
than rolling over every 60.
 
Back
Top