LinkBack URL
About LinkBacks
Hi, I am attempting to take an end time-start time and I need the output to be in decimal form.
I have the initial duration set in h:mm time. Is there a way to complete what is shown below?
1:30 -> 1.5
1:10 -> 1.167
1:20 -> 1.33
Thank you!
Hi, I am attempting to take an end time-start time and I need the output to be in decimal form.
I have the initial duration set in h:mm time. Is there a way to complete what is shown below?
1:30 -> 1.5
1:10 -> 1.167
1:20 -> 1.33
Thank you!
Last edited by JessicaW; 10-02-2012 at 05:55 PM.
=hour(a1)+minute(a1)/60 is your safest bet.
Depending on the numbers you really have, you could just use =a1*24 and set the format to general.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Try this:
Format the cell as General.
=HOUR(E2)+MINUTE(E2)/60
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks