LinkBack URL
About LinkBacks
I need to convert time -Hours,minutes- to a decimal. using timevalue I have to input timevalue("string"). I have a lot of these to do. is there a way to do it faster. Macro ?
I need to convert time -Hours,minutes- to a decimal. using timevalue I have to input timevalue("string"). I have a lot of these to do. is there a way to do it faster. Macro ?
you can do it easier, could you suply a sample of your layout?
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Hi Tom, welcome to the forum.
Can you provide a few examples of how you want the decimals to appear? For example, do you want 8:30am to be 8.5 or 8.3? Do you want 8:30pm to be 20.5 or 8.5? Or 20.3/8.3?
For 8.5 and 20.5, respectively, you can simply use:
=A1*24
Where A1 contains the time value. You can fill that down the column for multiple values.
To get the x.3 variety, you could try:
=INT(A1*24)+MINUTE(A1)/100
Hope that helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks