Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() This is my first post so hello everyone and thankyou in advance for any assistance you can provide. The diffuclty I am having is as follows: I have a spreadsheet containing two times 8:45 and 9:45 I need to find the difference in the two times as a decimal but also as a fraction of an hour.. for these times the answer I need is 0.25 not 0.15. i.e. a quarter of an hour Can anyone help? -- bcbjork ------------------------------------------------------------------------ bcbjork's Profile: http://www.excelforum.com/member.php...o&userid=26665 View this thread: http://www.excelforum.com/showthread...hreadid=399414 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate the difference two times | Excel Discussion (Misc queries) | |||
Calculate the difference between two times | Excel Worksheet Functions | |||
Difference between 2 times and dates | Excel Worksheet Functions | |||
how do I figure the difference between two times when one is in p. | Excel Worksheet Functions | |||
How can I calculate the difference between times without using th. | Excel Worksheet Functions |