| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
In Excel how can you convert a cell formatted for time (4:30) to .
I've compiled an excel sheet for tracking my working hours to calculate at
the end of the week my pay due. The final column displays the total work hours as 20:30 (20 Hrs 30 Mins). I would like to know how I can convert this to read 20.5 Hrs. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
| Improve Convert function in Excel | Excel Worksheet Functions | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) | |||
Threaded Mode
