Excel sees a day as being =1. An hour is thus =1/24, a minute to 1/1440, etc...
So if the data is expressed as real time ( 00:10:00, say) you can replace 60 ( decimal value) by 1/24 ( time value)
Be aware that in some cases you can have a text string looking like time (underlying value is text) instead of being real time (underlying value is a number as described before)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Last edited by Pecoflyer; 11-19-2013 at 01:43 AM.
|