Hi
Excel sees a day as 1 - an hour as 1/24 a minute as 1/1440, etc
To return to decimal you should multiply by 24
So, 48 minutes are 24*(48/1440) which you can subtract from the result you have obtained
Hi
Excel sees a day as 1 - an hour as 1/24 a minute as 1/1440, etc
To return to decimal you should multiply by 24
So, 48 minutes are 24*(48/1440) which you can subtract from the result you have obtained
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks