Time Difference shown as fraction of hour

C

Colin Eames

I want to show the difference between two times (entered as 09:15 and 12:45 for example) as a fraction of hours (eg 3 1/2 hours)
 
B

Biff

Hi Colin,

Fraction or decimal? The difference would be in formatting.

=(12:45-09:15)*24

format as GENERAL for a result of 3.5
format as FRACTION for a result of 3 1/2

Biff


-----Original Message-----
I want to show the difference between two times (entered
Click to expand...
as 09:15 and 12:45 for example) as a fraction of hours (eg
3 1/2 hours)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Calculating the difference, in hours, between two date/time in two different time zon 2
Work Budget Salary vs Real Time Salary 0
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0
15 minute data to daily data 1
separating date and time 5
How to modify and updte specific styles for specific paragraphs across the document 0

Top