Hi
I have developed this VBA formula to retrieves any decimal I input in a range into hour (Please check the attachment)
But the problem is it only gives me up to 23 hours, when it gets to 24 it gives me zeros all because I have had formatted the cells as time.
Its working very nice if I input 0.23 or any decimal up to 23 hours but I want to be able to input up to 100 hours or more.
This is my formula:
![]()
Please Login or Register to view this content.
Bookmarks