Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
Converting Standard Time into Military Time | Excel Discussion (Misc queries) | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) |