Shanmugam
09-04-2008, 10:38 AM
Hi,
Can you please help me how to calculate this two time difference:
A1 (cell): 10:39PM (date: 9/3/08)
A2 (cell): 04:00AM (date: 9/4/08)
How to calculate A2-A1? (its showing me #VALUE! error). Is there any formula to calculate this?
Thanks,
Shanmugam
Can you please help me how to calculate this two time difference:
A1 (cell): 10:39PM (date: 9/3/08)
A2 (cell): 04:00AM (date: 9/4/08)
How to calculate A2-A1? (its showing me #VALUE! error). Is there any formula to calculate this?
Thanks,
Shanmugam