How Enter Amount of Time hh:mm and Sum Time?

  • Thread starter Thread starter TomBrooklyn
  • Start date Start date
T

TomBrooklyn

How does one enter times in hours and minutes or hours, minutes an
seconds? I want to enter amounts of time, not time of day. I see
to keep getting stuck with time of day, and with some settings I'm no
sure if it's time of day or amount of time.


After I get this, how can I sum the daily amounts of time going acros
a row to get a weekly total amount of time, and then sum the weekl
totals in the weekly total column to get a monthly total amount o
time?

TomBrookly
 
Hi

Format the cells as [hh]:mm from the Custom option. Enter your data with a
colon in (13:30) and Excel will treat it as hours:mnutes. The square
brackets mean that the hours will roll-over, so 34:00 will be classed as 34
hours and not 1 day and 10 hours. You can just sum these figures the same as
normal numbers.
 
Hi
just enter the amoiunt of times in the format hh:mm. Also format this
cell with the custom format
[hh]:mm

To add these amoiunts simply use =SUM(A1:A10) and also format the
resulting cell with
[hh]:mm
 
Back
Top