View Single Post
 
Old 11-18-2013, 01:40 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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.
Reply With Quote