Time Counting

[Rhon Alvarez]

Hi Team,

Once again, I am asking for help with the excel time computation.

Is there a way wherein a data was written in time as 1496:11:02 (hh:mm:ss) could be extracted as an equivalent value separately?

ie: hour = 1496 ; minute = 11 & seconds = 2

please refer to the attached file.

Thanks in advance.

 

[AliGW]

Try this:

=DATE(YEAR(B2),MONTH(B2),DAY(B2))*24+HOUR(B2)

=MINUTE(B2)

=SECOND(B2)

Set the cell formatting to general.

 

[Rhon Alvarez]

Hi AliGW,

that was great. thanks for the immediate help..

 

[AliGW]

You're welcome!

 

[John Jairo V]

Hi, to both!

In B10, you can use:
=INT(24*B2)

Blessings!

 

[vletm]

Rhon Alvarez
Shorter formulas, use correct formats.
D..F -column times ... hmm?

 

[Rhon Alvarez]

Hi Vietm,

Unfortunately, there is a certain computation needed. I need to sum up the total number of Hours + (minutes/60) + (seconds/3600)

the reason why i asked for help in segregating each as a value so that i can make the computation before summing it all up.

thanks for the help though...

 

[vletm]

Rhon Alvarez
If calculate times then why You won't calculate those like times?
Why need to change some parts to minutes and seconds?
Take care that format are correct.
If You calculate days and times,
then be careful eg 3350155 is days no matter of header.
... but of course it's Your choice

 

[Rhon Alvarez]

Hi Vltm,

because we need to convert everything only in hours, that is why minutes are divided by 60 and seconds are by 3600. it's kind of a requirement from our business. Of course you cannot have exactly an hour from every employees' time in and time out. So we have to make a work around from the data that we can extract. it so happens that it is what the system is giving us. hh:mm:ss