| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time conversions
I am trying to convert some times in my spreadsheet. I know how to convert
mins. to hrs but the problem I am having is this for example: I need 39.20 to show as 39.33. Does any one know the formula or how I can do this????????? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time conversions
=A1*24 with A1 formatted as [hh]:mm
"Holsapple" wrote: I am trying to convert some times in my spreadsheet. I know how to convert mins. to hrs but the problem I am having is this for example: I need 39.20 to show as 39.33. Does any one know the formula or how I can do this????????? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time conversions
Assuming you meant 39.20 not 39:20, try
=INT(A1)+ROUND(MOD(A1,1)*100/60,2) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Holsapple" wrote in message ... I am trying to convert some times in my spreadsheet. I know how to convert mins. to hrs but the problem I am having is this for example: I need 39.20 to show as 39.33. Does any one know the formula or how I can do this????????? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time conversions
THANK YOU SOOOOOOOOOO MUCH. That was it. You saved me like 5 hours.
"Bernard Liengme" wrote: Assuming you meant 39.20 not 39:20, try =INT(A1)+ROUND(MOD(A1,1)*100/60,2) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Holsapple" wrote in message ... I am trying to convert some times in my spreadsheet. I know how to convert mins. to hrs but the problem I am having is this for example: I need 39.20 to show as 39.33. Does any one know the formula or how I can do this????????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
| formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
| Hot key for time? | Excel Worksheet Functions | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Time calculations & text conversions | Excel Discussion (Misc queries) | |||
Linear Mode
