in this video I'm gonna talk about hours minutes and seconds in Excel I had a
problem that was sent to me by a lady she was trying to calculate the time
spent on each task and total one and so the the first big trick in working
hours minutes and seconds in Excel is you need to separate the hours minutes
and seconds by colons so let's put in the first one and let's go 8 let's say
they started at 8 and they started 805 and then another colon
and then they started at 8:05 zero zero and then the end time would be 10 colon
3 0 colon 2 5 now you can subtract these and select
the end time minus the start time and you're left with the actual time that
was to complete this task now you can also multiply this so we have 2 hours
and 25 minutes and 25 seconds now if we're gonna do this every day for a week
so we multiply times 5 and there you go that that's how many hours you're gonna
spend on this for the week now if we had just we just wanted to calculate and it
works out to just hours you're still gonna have to have the rest of the of
the rest of the formatting in there so for example in our second example we
have 10 : 45 : 11 and our end time is 10 : 51 3 0 now if we drag down this
formula that we have here we we end up 5 minutes and 19 seconds now if you don't
include the zeroes the other to add the formatting you
won't be able to add these numbers properly at the end and once again we
can drag down this formula here and so if they did this for five for five days
in a row this is what the time would be and the last the last one we're gonna do
is we're gonna do for it when it's just seconds so let's go 11 : 0 1 : 0 3 and
then we're gonna go 11 : 0 1.55 the difference of that is only 52 seconds
now it's important to be able to add both the hours and the minutes even
though it's 52 seconds so if we're gonna sum me so I'm gonna do an automatic sum
there so they can calculate how many hours I spent doing these tasks they've
spent 2 hours and 31 minutes and once more if we can multiply this and then
you can get and bring this down again so if you carry all your of digits
you are able to subtract your time to get the actual time that was accrued
you're able to multiply your time to get the the time times number of days in the
week and you're able to total your time so it's important that you carry the
formatting with the hours separated by a colon and the minutes separated between
that and : s seconds this is how you work with hours minutes and seconds
please subscribe