Bob Hoath

Posts: n/a

Time in formulae

I have a time value in a cell (A1) formatted hh:mm. Say the value is 20:00.
In cell B1 I am trying to write a formula IF(A117:00,A1-17:00,0). This
should give me an answer 3:00 but I get error reports. I have tried
enclosing in brackets but to no avail. Any suggestions please?

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
entering numbers to display a time format	Ian Williams/Eazygig	Excel Discussion (Misc queries)	1	January 10th 05 11:57 AM
Help - Information with time and date	PM	Excel Discussion (Misc queries)	4	January 6th 05 08:25 AM
time sheet	Rusty Boy	Excel Worksheet Functions	2	December 2nd 04 03:49 PM
Round Time	cpme	Excel Worksheet Functions	2	November 18th 04 07:09 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	4	November 18th 04 03:24 PM

All times are GMT +1. The time now is 06:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us