| 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. |
|
#2
|
|||
|
|||
|
=H1*24 and format as general.
-- HTH RP (remove nothere from the email address if mailing direct) "Lisa" wrote in message ... 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. |
| Reply |
| 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) | |||
Linear Mode
