Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
hours to fractions
Hi, I have a 3 cell scenario. In the first cell is the time an employee starts a work day formatted under time. So entering a 9:00 would result in 9:00:00 AM. The second cell is the time an employee clocks out formatted the same way. So 5:30 PM would give 5:30:00 PM In the last cell, I want the total time worked to be displayed. Right now, by subtracting the 2nd cell from the 1st... I get 8:30 as a result. Which is correct... 8.5 hours... but I want it displayed as 8.5 and not 8:30. How can I do this? Thanks to any and all who reply!! -- jkwok ------------------------------------------------------------------------ jkwok's Profile: http://www.excelforum.com/member.php...o&userid=28428 View this thread: http://www.excelforum.com/showthread...hreadid=480240 |
#2
|
|||
|
|||
hours to fractions
Multiply with 24
=D2*24 D2 holds the time difference it is important that you format the cell as either general or number NOT time -- Regards, Peo Sjoblom "jkwok" wrote in message ... Hi, I have a 3 cell scenario. In the first cell is the time an employee starts a work day formatted under time. So entering a 9:00 would result in 9:00:00 AM. The second cell is the time an employee clocks out formatted the same way. So 5:30 PM would give 5:30:00 PM In the last cell, I want the total time worked to be displayed. Right now, by subtracting the 2nd cell from the 1st... I get 8:30 as a result. Which is correct... 8.5 hours... but I want it displayed as 8.5 and not 8:30. How can I do this? Thanks to any and all who reply!! -- jkwok ------------------------------------------------------------------------ jkwok's Profile: http://www.excelforum.com/member.php...o&userid=28428 View this thread: http://www.excelforum.com/showthread...hreadid=480240 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating hours | Excel Worksheet Functions | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
calculate hours just can't figure it out | Excel Worksheet Functions | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |