LinkBack URL
About LinkBacks
Hi
To obtain the serial number of a number of hours.
Ex: 70:30 = 2.9375
Thank you!
Hi
To obtain the serial number of a number of hours.
Ex: 70:30 = 2.9375
Thank you!
Last edited by marreco; 04-01-2012 at 07:59 PM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Just have a cell equal to the one holding the hour value and format it as General.
Cool, I liked it but could you tell me if you have any way to make a formula?
Thank you!
Last edited by marreco; 04-01-2012 at 07:41 PM.
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?
If A1 = 70:30 how would the calculation in B2?
In B2 you would have:
=A1
and formatted as General
If you want a formula it would be:
=A1*1
and formatted as General
Thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks