Manuals/calci/HOUR

Revision as of 20:36, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Syntax


Examples


'''''''  ''''

Description


HOUR 


 

HOUR(sn)

where sn   is the time which contains the hour .


 

This function gives the hour of a time value.


 Let's see an example in Column1Row1

C1R1 = 5:45:30 AM

I.e.=HOUR(C1R1) is 5

///rly for 5:45:30 PM

I.e =HOUR(C1R1) is 17

///rly C1R1=17:30

I.e.=HOUR(C1R1) is 17



Column1 Column2 Column3 Column4
Row1 5:45:30 AM 5 5:45:30 PM 17
Row2
Row3
Row4
Row5
Row6