Posted to microsoft.public.excel.programming

Senaka Excel Senaka Excel is offline

external usenet poster

Posts: 1

how to use if command with time in function?

give example?
if in B2 cell having a time format how to identify it by using IF function?
to calculate overtime hours and minutes.
=(ifB20900,"yes","no")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to use time with an If command?	[email protected]	Excel Worksheet Functions	1	February 18th 08 11:05 PM
Run-Time error 13 on a FileOpen command	Willibrord Koot	Excel Programming	2	October 3rd 05 08:12 AM
Wait time before next command	John	Excel Programming	4	July 1st 05 04:31 PM
@ NOW time command	Time study Guy	Excel Discussion (Misc queries)	2	January 25th 05 04:50 PM
Command Button run-time error	Dominique Feteau	Excel Programming	1	June 29th 04 02:57 AM

All times are GMT +1. The time now is 10:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us