Converting time
I have 325.42 minutes, if I subtract the actual time of day (start - 9:13
from finish of 14:38) i get 5 hrs and 25 minutes. If I use the convert formula or divide by 60 i get 5 hrs and 42 min. How can i arrive at 5 hrs and 25 minutes |
Converting time
With your data in A1, enter:
=A1/24/60 and format as time to display: 5:25:25 AM -- Gary''s Student - gsnu200810 "Mark" wrote: I have 325.42 minutes, if I subtract the actual time of day (start - 9:13 from finish of 14:38) i get 5 hrs and 25 minutes. If I use the convert formula or divide by 60 i get 5 hrs and 42 min. How can i arrive at 5 hrs and 25 minutes |
Converting time
Mark
With your munutes in a1 try this =A1/1440 format as hh:mm Mike "Mark" wrote: I have 325.42 minutes, if I subtract the actual time of day (start - 9:13 from finish of 14:38) i get 5 hrs and 25 minutes. If I use the convert formula or divide by 60 i get 5 hrs and 42 min. How can i arrive at 5 hrs and 25 minutes |
Converting time
Dividing by 60 or using =CONVERT(cell_ref,"mn","hr") you *don't* get 5 hrs
and 42 minutes, you get 5.42 (and a bit) hours. [Note 5.42 with a decimal point, not 5:42 with a colon]. 0.42 (and a bit) hours gives 25 (and a bit) minutes. If you want to convert your decimal minutes to hours and minutes, use =A2/(24*60) or =CONVERT(A2,"mn","day"), and in either case format as time, with a time format to suit your preferences. Alternatively, use =TEXT(A2/(24*60),"hh:mm") if you want the answer as text. -- David Biddulph "Mark" wrote in message ... I have 325.42 minutes, if I subtract the actual time of day (start - 9:13 from finish of 14:38) i get 5 hrs and 25 minutes. If I use the convert formula or divide by 60 i get 5 hrs and 42 min. How can i arrive at 5 hrs and 25 minutes |
All times are GMT +1. The time now is 01:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com