|
|
#1
04-08-2017, 09:23 AM
|
|||
|
|||
Converting number to hours
I have made a time sheet & the overtime for night shifts at weekend's I have had to put in a formula for negative hours, this is only displayed has text or numbers. the value in the cell is 6 & can be viewed has text or numbers, I need to convert this number in a different cell still has 6 but formatted has hours. Many thanks 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Holiday report excel - pull +/- hours from cells containing text and number | bobby123456789 | Excel | 2 | 12-09-2016 09:05 AM |
 How to create a table with a number of line depending a number entered by user
|
Cellendhyll | Word Tables | 3 | 07-10-2014 05:49 AM |
|
Converting serial number to years, months and days
|
hannu | Excel | 6 | 02-14-2013 09:21 PM |
| Converting hh:mm to hours | Sammael | Excel | 2 | 04-17-2012 01:33 PM |
|
Converting decimal to hours
|
jhwtsang | Excel | 4 | 05-16-2011 01:36 PM |
Windows 10 
Office 2010 64bit
Threaded Mode