changing time

bendibendi
edited April 2005 in Internet & Media
Hi,
How can i change time format (with a formula) on data in excell sheet'
e.g 21:12:05 (21 hours' 12 minutes' 05 seconds) to be dislpayed only in minutes.
insted of 21:12:05 i need it to be shown as 1272.083
Thanks,
Bendi

Comments

  • 07mavribea07mavribea Perth, Western Australia
    edited April 2005
    im not sure about the whole lot, but i can help if you have a seperate cell for hours, minutes and seconds. Hours into minutes would be *60. Minutes is *1 and seconds would be seconds/60. Then you just add all 3 coloums. I hope this can help but doesn't really answer you question of having hh:mm:ss. :scratch:
  • shwaipshwaip bluffin' with my muffin Icrontian
    edited April 2005
    If you type in the time (21:12:05) into A1 and you want the actual time in minutes in A2, use the formula "=A1*24*60". Make sure that A2 is formatted properly (General or number, NOT time)
Sign In or Register to comment.