Hours mins to decimal

Paul C · #1 06-09-2017, 05:53 AM

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

xor · #2 06-09-2017, 06:31 AM

With hours and minutes in A1:

=A1*24*60 (format as General).

Paul C · #3 06-09-2017, 06:41 AM

Thank you. Although calculating correctly, 29 hours still displays as a date in formula bar.

xor · #4 06-09-2017, 06:57 AM

I can't replicate that!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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