View Single Post
 
Old 05-23-2017, 04:36 AM
shabbaranks shabbaranks is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Mar 2011
Posts: 89
shabbaranks is on a distinguished road
Default Getting difference in time as a decimal and percentage of an hour

Hi,

I was wondering if anyone can help please? Im looking to subtract an end time from a beginning time and then display that as a decimal and then take that decimal and convert it to a percentage of an hour(s) can anyone help?

As an example:

Start Time - 11:15
End Time - 13:30
Time in decimal - 2.25

As its 2 and a quarter hours

Thanks
Reply With Quote