Follow Us on Facebook

វចនានុក្រមខ្មែរ​
Khmer Dictionaries

Follow us on Twitter

Google+

Search More Information

Friday, March 21, 2014

TIME Function in Excel 2010

The decimal number returned by TIME is a value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).
Syntax:
                =TIME(hour, minute, second)


TIME Function

A
B
C
1
Serial_Number
3/20/2014 15:42
 =NOW()
2
 =HOUR(B10)
15

3
 =MINUTE(B1)
42

4
 =SECOND(B1)
21

5
 =TIME(B2,B3,B4)
3:42 PM

0 comments :

Post a Comment

Like Me on Facebook

Donation by PayPal

Blog Archive

Loading...