From: ijustlivehere on 24 May 2010 11:46 What if I go over midnight? "Peo Sjoblom" wrote: > Multiply by 24 and format as general or number > > > =A2*24 > > > > -- > > > Regards, > > > Peo Sjoblom > > "3Nails" <3Nails(a)discussions.microsoft.com> wrote in message > news:8902FC93-C724-4E4A-8DF3-47331D51EB90(a)microsoft.com... > > Calculated hours and mintues from time; > > > > 16:00 (4PM) to 19:30 (7:30PM) is 3:30. > > > > How can I convert the results 3 hours and 30 minutes to 3.5 hours? > > > From: Fred Smith on 24 May 2010 16:26 See your other post. Regards, Fred "ijustlivehere" wrote in message news:7FA2471B-10AD-4F66-B0A3-334CFA2A0EDC(a)microsoft.com...> What if I go over midnight? > > "Peo Sjoblom" wrote: > >> Multiply by 24 and format as general or number >> >> >> =A2*24 >> >> >> >> -- >> >> >> Regards, >> >> >> Peo Sjoblom >> >> "3Nails" <3Nails(a)discussions.microsoft.com> wrote in message >> news:8902FC93-C724-4E4A-8DF3-47331D51EB90(a)microsoft.com... >> > Calculated hours and mintues from time; >> > >> > 16:00 (4PM) to 19:30 (7:30PM) is 3:30. >> > >> > How can I convert the results 3 hours and 30 minutes to 3.5 hours? >> >> >>  |  Pages: 1 Prev: IF ERROR FORMULANext: Converting Hours to Decimal