I'm having trouble converting hours to numbers. I am attaching a file. thank you in advance for your help.

And if you enter = F3 * 24 and give the number format of the cell, it doesn't work?

I understand you want to convert sexagesimal system to decimal system. Divide the minutes by 60: Code: text Expand Select all Copy to clipboard=MINUTA(F3)/60

it worked, thanks for your help. Added after 2 [minutes]: Unfortunately, this formula did not help me because the result was 0.75 but thank you for your statement. The kernel-panic solution worked. greetings.

Excel: Converting Hours to Numbers - File Attached, Seeking Guidance

| New topic

#1 13230538 28 Jan 2014 12:53

tasiek87pl tasiek87pl

Level 2
» |

Post #1
13230538 28 Jan 2014 12:53

I'm having trouble converting hours to numbers. I am attaching a file. thank you in advance for your help.

Attachments:

czasowy_problem.xls Download (29 KB)
ADVERTISEMENT
Helpful post

#2 13230661 28 Jan 2014 13:27

kernel-panic kernel-panic

Level 16

» | Helpful post? (+3)

Helpful post
Post #2
13230661 28 Jan 2014 13:27

And if you enter = F3 * 24 and give the number format of the cell, it doesn't work?
ADVERTISEMENT
#3 13231008 28 Jan 2014 15:11

markoz7874 markoz7874

Level 31
» | Helpful post? (+3)

Post #3
13231008 28 Jan 2014 15:11

I understand you want to convert sexagesimal system to decimal system.
Divide the minutes by 60:

Code: text Expand Select all Copy to clipboard
=MINUTA(F3)/60
#4 13232795 28 Jan 2014 21:45

tasiek87pl tasiek87pl

Level 2
» | Topic author Helpful post? (0)

Post #4
13232795 28 Jan 2014 21:45

kernel-panic wrote:
And if you enter = F3 * 24 and give the number format of the cell, it doesn't work?

it worked, thanks for your help.

Added after 2 [minutes]:

markoz7874 wrote:
I understand you want to convert sexagesimal system to decimal system.
Divide the minutes by 60:

Code: text Expand Select all Copy to clipboard
=MINUTA(F3)/60

Unfortunately, this formula did not help me because the result was 0.75 but thank you for your statement. The kernel-panic solution worked. greetings.
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

| New topic

Report a violation of the law

Excel: Converting Hours to Numbers - File Attached, Seeking Guidance

Didn't find an answer? Ask Artificial Intelligence