Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert time
hi
i have a field on a worksheet formatted as [h]:mm:ss i would like to convert this to decimal time i.e 29:26:24 = 29.43 can anyone please tel me the formula thanks kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert time
Hi Kevin,
Am Thu, 31 May 2012 05:21:37 -0700 (PDT) schrieb kevcar40: i have a field on a worksheet formatted as [h]:mm:ss i would like to convert this to decimal time i.e 29:26:24 = 29.43 your time in A1, then in B1: =A1*24 and B1 formatted as General Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert time
On Thursday, May 31, 2012 1:21:37 PM UTC+1, kevcar40 wrote:
hi i have a field on a worksheet formatted as [h]:mm:ss i would like to convert this to decimal time i.e 29:26:24 = 29.43 can anyone please tel me the formula thanks kevin thanks some time the obvious is missed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert time stored as decimalised number to time format | New Users to Excel | |||
How do i convert unix time to Julian time in excel? | Excel Discussion (Misc queries) | |||
In Excel, I want to convert Eastern time to pacific time | Excel Discussion (Misc queries) | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) |