Getting difference in time as a decimal and percentage of an hour

shabbaranks · #1 05-23-2017, 04:36 AM

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

xor · #2 05-23-2017, 05:01 AM

=(13:30-11:15)*24 format as General.

shabbaranks · #3 05-23-2017, 07:22 AM

Quote:

Originally Posted by xor

=(13:30-11:15)*24 format as General.

Worked a treat - thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
subtract date and time and convert to decimal hours ?	DBenz	Excel	5	01-26-2017 05:38 AM
What is the formula for getting the percentage for time	phoenix666!	Excel	1	07-29-2016 08:18 AM
Time difference overnight	medavidcook	Excel	3	06-04-2015 05:01 AM
Formula for decimal hours from two date time entries	DBenz	Excel Programming	0	01-15-2015 05:52 AM
Time allotted minus time used with result in hour and minute	esther6086	Excel	2	04-29-2014 05:03 PM