# Turns hours in serial number

1. ## Turns hours in serial number

Hi
To obtain the serial number of a number of hours.
Ex: 70:30 = 2.9375

Thank you!

2. ## Re: Turns hours in serial number

Just have a cell equal to the one holding the hour value and format it as General.

3. ## Re: Turns hours in serial number

Cool, I liked it but could you tell me if you have any way to make a formula?
Thank you!

4. ## Re: Turns hours in serial number

I don't know what you're trying to do.
The serial number for 1 hour is 1/24 so the formula for any time value would be Hours/24 or in your sample 70.5/24
Is that what you mean?

5. ## Re: Turns hours in serial number

If A1 = 70:30 how would the calculation in B2?

6. ## Re: Turns hours in serial number

In B2 you would have:
=A1
and formatted as General
If you want a formula it would be:
=A1*1
and formatted as General

7. ## Re: Turns hours in serial number

Thank you!!!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1