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 PNG to JPEG Online Free | No Software Required

Learn basic formulas and functions of Excel in 5 minutes

Understanding MIN and MAX function in Excel

Round Time to the Nearest 15 Minutes in Excel - MROUND Formula

Excel: Pop Up Message on Cell Value Change

How to make an Online Quiz with Microsoft Forms

How to Make a Multiplication Table in Python Fast

4-20 mA Signal Basics Explained Simply | Part 1

📦 喺網上打開同提取 TAR.GZ/TGZ 檔案 – 唔需要任何軟件！[Cantonese] ([粵語])

How Canva’s AI Tool 'Code for Me' Revolutionizes Web Design for Beginners

Create Dynamic Forms with MakeForms and Boost Your Conversions

How To Use DALL-E 2 (2024) Tutorial To Make And Edit Images With Artificial intelligence

Don't let SQL divide by zero ruin your day | Essential SQL

LG UA75 TV Full Setup and App Control

Phones Are Getting Weirder...

Up next in 10

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

howtoexcelatexcel.com