helloitsdean
New Member
- Joined
- Apr 23, 2018
- Messages
- 5
Hi everyone,
I have a very simple spreadsheet that looks like this:
[TABLE="width: 429"]
<tbody>[TR]
[TD]Date Started[/TD]
[TD]Time Started[/TD]
[TD]Date Finished[/TD]
[TD]Time Finished[/TD]
[TD]Hours[/TD]
[/TR]
[TR]
[TD]23/04/18[/TD]
[TD]06:00[/TD]
[TD]25/04/18[/TD]
[TD]06:00[/TD]
[TD]48[/TD]
[/TR]
[TR]
[TD]24/04/18[/TD]
[TD]07:00[/TD]
[TD]25/05/18[/TD]
[TD]09:00[/TD]
[TD]746[/TD]
[/TR]
[TR]
[TD]25/04/18[/TD]
[TD]08:00[/TD]
[TD][/TD]
[TD][/TD]
[TD]-1037168[/TD]
[/TR]
</tbody>[/TABLE]
The hours cell contains a formula that calculates the difference between two sets of date/time, eg =((C3+D3)-(A3+B3))*24
That works fine enough but what I want is to add an IF function that would first look at the date finished and the time finished cells, and if they are blank, it would return the hours passed based on the current date/time, and if they have data, then use the above formula instead.
Can anyone help me with this?
I have a very simple spreadsheet that looks like this:
[TABLE="width: 429"]
<tbody>[TR]
[TD]Date Started[/TD]
[TD]Time Started[/TD]
[TD]Date Finished[/TD]
[TD]Time Finished[/TD]
[TD]Hours[/TD]
[/TR]
[TR]
[TD]23/04/18[/TD]
[TD]06:00[/TD]
[TD]25/04/18[/TD]
[TD]06:00[/TD]
[TD]48[/TD]
[/TR]
[TR]
[TD]24/04/18[/TD]
[TD]07:00[/TD]
[TD]25/05/18[/TD]
[TD]09:00[/TD]
[TD]746[/TD]
[/TR]
[TR]
[TD]25/04/18[/TD]
[TD]08:00[/TD]
[TD][/TD]
[TD][/TD]
[TD]-1037168[/TD]
[/TR]
</tbody>[/TABLE]
The hours cell contains a formula that calculates the difference between two sets of date/time, eg =((C3+D3)-(A3+B3))*24
That works fine enough but what I want is to add an IF function that would first look at the date finished and the time finished cells, and if they are blank, it would return the hours passed based on the current date/time, and if they have data, then use the above formula instead.
Can anyone help me with this?