TIMEVALUE
This function will show an actual time based on a piece of text which looks
like a time. It is useful when data is imported from other applications, such as
from mainframe computers, which convert all values to text.
Syntax
like a time. It is useful when data is imported from other applications, such as
from mainframe computers, which convert all values to text.
Syntax
=TIMEVALUE(Text)
Formatting
Formatting
The result will be shown as a number representing the time a fraction of the day.
Formatting can be applied for either the 12 or 24 hour clock system.
Formatting can be applied for either the 12 or 24 hour clock system.

कोई टिप्पणी नहीं:
एक टिप्पणी भेजें