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
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 hhss.
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)
Comments