=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.
=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).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks