Convert Seconds To Minutes In Excel #excel #spreadsheetmagic #spreadsheet

0:00
hello everyone my name is Barbara today
0:02
I'm looking at the number of seconds in
0:04
a column which I have 165 for this
0:07
example and this is how long my staff
0:09
have been on site for each day so on the
0:12
second of the second they arrived at 725
0:14
and they were there for 165 seconds and
0:16
what I want to know is so I don't have
0:18
to manually do it all the time how many
0:20
minutes and seconds were they on site so
0:23
let's look at how to do that okay so
0:25
let's do 20 seconds on how Excel stores
0:27
time so one day is stored as 1 1 hour of
0:31
a day is stored as 1 / 24 which is this
0:35
decimal if we then move on to how many
0:37
minutes in a day let's look at um 1 / 60
0:43
by 24 and then if we look at seconds in
0:46
a day 1
0:48
/ 60 by 60 by 24 so we have a lot of
0:54
decimal numbers there but we don't have
0:56
to use the decimal numbers cuz what we
0:57
can do is we can easily just convert
0:59
that to time by selecting time and we
1:02
can see that that's 1 minute that's one
1:04
that's 1 second that's 1 minute that's 1
1:06
hour and that is a day so let's just
1:08
test it shall we let's look at um 120
1:12
seconds and let's calculate how many
1:14
minutes so that would be 60 * 60 * 24
1:18
and of course that should be 2 minutes
1:20
and let's just select that down and 165
1:24
is 2 minutes 45 seconds okay let's get
1:27
back to the normal programming okay so
1:29
we're back and we know how Excel handles
1:31
time and it's in a decimal format so we
1:33
can go straight ahead and just go okay
1:36
that's 165 and we want to divide that by
1:39
60x 60x 24 close the brackets and that
1:43
gives us another decimal as we expected
1:46
let's just double click and fill that in
1:48
we don't want to deal with the decimal
1:50
let's just go ahead and format that as
1:53
time so I know that
1:56
EU1199 was on site for 1 minute and 50
1:59
seconds the next day slightly longer and
2:02
so on and so forth and that is how you
2:05
calculate minutes and seconds from
2:07
seconds if that's how you get your
2:09
system data

Convert Seconds To Minutes In Excel #excel #spreadsheetmagic #spreadsheet

howtoexcelatexcel.com

How to Convert Numbers to Words in Excel

Learn 3 Excel tricks in 30 seconds! #shorts #excel

Power BI - Manually typing in a data table

Learn Excel Formulas Part 3: Excel Formulas to Calculate Percentages

Excel FILTER Function - Is this the Best Excel Function?

Dynamic Report with Values and Percentage on Column Chart in Excel

OBS Tutorial - How To Record Your Computer Screen for FREE!

Transform PDF Files Into Excel Sheets With Copilot

Excel Hack: Make Negative Numbers Vanish From Pivot Tables

How To Create Bar Graphs And Charts Using ChatGPT

How to Design an Interactive Dashboard in Excel—No Formulas, No Coding!

How to use Weeknum Formula in Excel | Excel Tutorial for Beginners in Hindi | Lesson - 17

Excel Mastery Unleashed: A Step-by-Step Guide on How to Use Copilot for Ultimate Efficiency 📊💻

Convert PDF to Excel File Without Losing Format | Editable Excel File

Analogue 3D Video Review

Up next in 10

Convert Seconds To Minutes In Excel #excel #spreadsheetmagic #spreadsheet

howtoexcelatexcel.com