Formulas and Functions
اس کنٹرول میں ترمیم کرنے سے یہ صفحہ آٹومیٹک طریقے سے اپڈیٹ ہو جائے گا

TIME

The TIME function converts separate number values for hours, minutes and seconds into a date/time value.

TIME(hours, minutes, seconds)

hours: The number of hours to include in the date/time value returned.

minutes: The number of minutes to include in the date/time value returned.

seconds: The number of seconds to include in the date/time value returned.

Notes

  • You can specify hour, minute and second values greater than 24, 60 and 60, respectively. If the hours, minutes and seconds add up to more than 24 hours, 24 hours are repeatedly subtracted until the value is less than 24 hours.

  • Any decimal portion in the hour, minute and second values is ignored.

Examples

=TIME(12,0,0) returns 12:00 pm.

=TIME(16,45,30) returns 04:45 PM.

=TIME(0,900,0) returns 3:00 pm.

=TIME(60,0,0) returns 12:00 pm.

=TIME(4.25,0,0) returns 4:00 am.

See alsoDATEDATEVALUETIMEVALUE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
مددگار؟
حروف کی حد: 250
حروف کی زیادہ سے زیادہ حد 250 ہے۔
آپ کے تاثرات کا شکریہ۔
Morty Proxy This is a proxified and sanitized view of the page, visit original site.