|
|
#1
06-09-2017, 05:53 AM
|
|||
|
|||
Hours mins to decimal
I wish to charge for a job based on hours and minutes and £60 per hour.
I am doing this by: column to insert hours and mins using [h]:mm format column to convert that to decimal using *24 formula column to convert that using *60 formula I initially had problems for any time over 24 hours but seem to have solved that except it displays in formula bar as a date. For example for 29 hours, 29:00 displays as 01/01/1900 05:00:00 can anyone help with display issue and also to suggest a quicker formula? many thanks 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| subtract date and time and convert to decimal hours ? | DBenz | Excel | 5 | 01-26-2017 05:38 AM |
| Convert [h]:mm:ss to Decimal Hours to Count FTE for Month | Ethan2015 | Excel | 2 | 09-18-2015 03:55 AM |
| Formula for decimal hours from two date time entries | DBenz | Excel Programming | 0 | 01-15-2015 05:52 AM |
 Converting decimal to hours
|
jhwtsang | Excel | 4 | 05-16-2011 01:36 PM |
|
Convert hours in decimal
|
ghostones | Excel | 1 | 12-29-2009 09:17 PM |
Windows 7 32bit 
Office 2013
Threaded Mode